Item order in ListBox

  • Thread starter Thread starter tony_bender
  • Start date Start date
T

tony_bender

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
 
Have you tried changing the code that loads the list boxes?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


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
 
Back
Top