| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
About list boxes
Hello,
Is there a method somewhere in the listbox object that will allow me to sort the entire listbox based on a column reference? If it is there I can't seem to find it. thank you, Keith |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About list boxes
I don't think there is one. You could copy your source to another range and
sort this, and then link this to the listbox - Mangesh "keith" wrote in message ... Hello, Is there a method somewhere in the listbox object that will allow me to sort the entire listbox based on a column reference? If it is there I can't seem to find it. thank you, Keith |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About list boxes
Can you sort the original range?
If not, John Walkenbach has a way: http://j-walk.com/ss/excel/tips/tip47.htm In fact, his sample code fills a listbox with unique entries with an optional sort. keith wrote: Hello, Is there a method somewhere in the listbox object that will allow me to sort the entire listbox based on a column reference? If it is there I can't seem to find it. thank you, Keith -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About list boxes
Hi Dave,
Thanks very much keith -----Original Message----- Can you sort the original range? If not, John Walkenbach has a way: http://j-walk.com/ss/excel/tips/tip47.htm In fact, his sample code fills a listbox with unique entries with an optional sort. keith wrote: Hello, Is there a method somewhere in the listbox object that will allow me to sort the entire listbox based on a column reference? If it is there I can't seem to find it. thank you, Keith -- Dave Peterson . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About list boxes
HI Mangesh
thanks very much keith -----Original Message----- I don't think there is one. You could copy your source to another range and sort this, and then link this to the listbox - Mangesh "keith" wrote in message ... Hello, Is there a method somewhere in the listbox object that will allow me to sort the entire listbox based on a column reference? If it is there I can't seem to find it. thank you, Keith . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
| Questions on combo boxes and list boxes. | New Users to Excel | |||
| List Boxes | Excel Programming | |||
| List boxes/combo boxes | Excel Programming | |||
| List boxes | Excel Programming | |||
Linear Mode
