Greg,

is it possible to sort the contents of a listbox

There is no built-in way to sort a list box.

is it possible to prevent items in a listbox being selected

You can disable the entire list box with
ListBox1.Enabled = False
but you cannot disable individual items in the list.

can you add items to a label in the same way as a listbox

I'm not sure what you mean, but I think the answer would be "no".

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"GREGORY" wrote in message
...
hello

3 things

is it possible to sort the contents of a listbox
is it possible to prevent items in a listbox being selected

can you add items to a label in the same way as a listbox


many thanks
Greg