View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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