Item order in ListBox

[tony_bender@yahoo.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

[Jim Cone]

Have you tried changing the code that loads the list boxes?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


<tony_bender@yahoo.com> wrote in message news:1150432278.231445.48260@g10g2000cwb.googlegroups.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