Hello!
I used the code from this dependent combobox thread:
http://www.excelforum.com/excel-prog...mbo-boxes.html
Woorkbook: Copy of Combo Box.xlsm
to create a list of unique items in my comboBoxes, and control the autofilter. But the items in the combobox are not in alphabetical/numerical order... how could I accomplish this?
Have you tried sorting them alphabetically first and then adding them to the combo box?
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Hi lnk2013
Check this link. It includes a download sample file for you to play with. C:\VBA Code\ComboBox\VBA ExpressExce...dered list.mht
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
This will sort a combobox or listbox:
E.g.,
Please Login or Register to view this content.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks