Item order in ListBox
How can I change the order of the items in a ListBox
I have a UserForm with a ListBox that displays ten sales zones. The
user selects one zone which then opens a second lListBox displaying the
individual markets within that zone. The problem is the items in the
ListBoxes automatically appear in alpha order but I prefer they appear
in a geographic sequence, for example West, Southwest, Midwest,
Southeast and Northeast. Can this be done?
TIA
|