ok thank you.
-----Original Message-----
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



.