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...