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