Sorting a List Box

[Guest]

I have a listbox that I need to sort. It is a list of names, followed by an
employee ID. I need to sort this list alphabetically. A straight alpha sort
should do the trick, as their last name comes first. The data is pulled from
a sheet that contains a greater number of employees, who are selected by the
appropriate department. The end result is that there is no specific range
that can be referenced or sorted within the source data. I need a routine
that will simply sort the items in the listbox alphabetically. Can someone
help me?

 

[MarMo]

Aaron ,
Take a look at this website :
http://www.dailydoseofexcel.com/archives/2004/05/12/sorting-listboxes/

maybe you'll find it usefull.
Regards
MarMo

 

[Guest]

This would be very useful, except that every time I try to pass my listbox to
the routine, it barks back at me and says "Run-time Error '424'": Object
Required