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


wrote in message ups.com...
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