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

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

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

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
.

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



.