Hi,
I have populated a listbox and now i'm trying to sort the contents alphabetically, i've tried
Listbox1.sorted=true
but i get a compile error, method or data member not found.
Can anyone help me?
TIA
Al
Printable View
Hi,
I have populated a listbox and now i'm trying to sort the contents alphabetically, i've tried
Listbox1.sorted=true
but i get a compile error, method or data member not found.
Can anyone help me?
TIA
Al
It is best to put your list into a worksheet range and sort there. You can refer to this range for the listbox or add items from there to the lb.
Code to sort lists is not straightforward - and will probably take longer.