I'm stumped. I have read threads and tried solutions for changing the RowSource property of a ComboBox using VBA.
I can type the Lookup!RangeName into the Properties box and it all works fine. But when I try something along the lines of UserForm.ComboBox.RowSource="Lookup!RangeName" nothing...