Item order in ListBox

Giganews Newsgroups
Subject: Item order in ListBox
Posted by:  tony_bend…
Date: 15 Jun 2006

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?