Hi, i was wondering if there is any instruction to order (by number or alpha) a combobox or a listbox. currently i have a function that compares each one of the entries and orders it but when I go over 500 entries it takes quite a while.
pd: is .zorder what im looking for? cause if it is its not working
Hi
How are you populating the List/Combo Box?
Single / Multi collumn?
ZOrder refers to the placement of the control and doesn't have anything to do with the data in the control.
Like jindon stated, it will depend on how you are filling the control. If you are using a Row Source, then just make sure the data is already sorted. If you are using AddItem, then just make sure the data is sorted first.
For Add Item, what I would do (assuming the starting data is not sorted and you do not want to change it to be sorted) is load all the data to an usused column, then sort the column, load the data to the control, then clear the data in the column.
It is far more efficient to NOT use Excel's built-in sorting.Originally Posted by Maka
See http://www.standards.com/index.html?Sorting.
Posting Permissions
Reply With Quote
