You cannot selectively change the color of items in a ListBox. You can
remove items by reference to there index number.

--

Regards,
Nigel




"Paul Tikken" wrote in message
...
Hi,

I've got a userform in wich i've got a several listboxes of values you can
choose from, these values are coming from several lists (lets say; A1:A100
for listbox 1 C1:C100 for listbox 2) in a worksheet(SHEET1). What i would
like is that when I choose a value in listbox 1 that this value is not
longer
available is this listbox, turns grey or something like that, so that it
cannot be choosen a second time.

For listbox 2 I would like the following, the contents of this listbox are
being used to fill out columns F and G. Listbox 2 contains a number
sequence
(0, 77, 100, 177, 200, 277, 300, 377, 400, 477, 500 etc, so only octals).
So
if number 77 is used to fill out column F and number 300 is used to fill
out
column G, I would like to see not only these two numbers turn grey, but
also
the numbers in between.

Any ideas?

Paul