Specifies whether the list of automatically completed strings is sorted.
|One of the objects listed in the Applies To section
This property applies to the following objects:
LookupItems property lets you determine whether the list of automatically completed strings specified by the
LookupItems property is sorted. If
LookupItems is True, the string list is sorted alphabetically. If this property is False, the string list is not sorted.
To sort the
LookupItems list, set
LookupItemsSorted to True. You can sort the string list in the User Forms editor as well as in scripts.
This property affects the order in which the automatically completed strings appear in the component. Suppose that the
LookupItems list contains the following strings: “James”, “Jack”, “Jane”, “Jake”, and the
LookupItems property is False. When the user types “Ja” into the component, it completes the first string from the
LookupItems list which starts with these characters and completes the string “James”. If you set
LookupItems to True then the
LookupItems list will be sorted alphabetically, as follows: “Jack”, “Jake”, “James”, “Jane”. Now, if the user types “Ja” into the component, the string “Jack” is automatically completed since it is the first string which starts with the entered characters.
True, if the
LookupItems list is sorted alphabetically; False if the list is not sorted. The default value is False.