Listbox - sorting alphabetically?

[Pienpeas]

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

[BrianB]

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.