Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting a List Box
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting a List Box
Aaron ,
Take a look at this website : http://www.dailydoseofexcel.com/arch...ing-listboxes/ maybe you'll find it usefull. Regards MarMo "Aaron Dyck" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting a List Box
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 "MarMo" wrote: Aaron , Take a look at this website : http://www.dailydoseofexcel.com/arch...ing-listboxes/ maybe you'll find it usefull. Regards MarMo "Aaron Dyck" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting a list | Excel Worksheet Functions | |||
List sorting | Excel Discussion (Misc queries) | |||
Sorting a list | Excel Discussion (Misc queries) | |||
Sorting list | Excel Programming | |||
Sorting a List | Excel Discussion (Misc queries) |