Add items to Userform Combobox based on Listbox values

[sharky12345]

I have a Listbox on a Userform which is populated like this;

ListBox1.RowSource = Range(Sheet4.Range("Z2"), Sheet4.Range("Z65536").End(xlUp)).Address(, , , True)

What I need to do is populate a range of Comboboxes with values from that Listbox - so if a value disappears from the Listbox it's not available in any of the Comboboxes which currently have no value selected. I only need this to apply to those comboboxes which currently have no value.

Not sure if it matters, but all of the comboboxes are named Combo1, 2 and 3 and so on, up to 20.

 

[ranman256]

you add items by adding values to the range.
I automatically validate the range upon form opening....
get the # rows in the range
set the combo .rowsource to this range