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 happens. I type it into the _Change parameter of the ComboBox and have tried other variants but nothing happens.
From other reading, I assume the Property RowSource input is an Initialise event but this doesn't help me much and I need to concatenate two sources into the single ComboBox. I will also need to make subsequent ComboBoxes dynamic so I could really use a few pointers as how to get past the first hurdle.
I expect I'm doing something daft, but any help would be welcomed.
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 happens. I type it into the _Change parameter of the ComboBox and have tried other variants but nothing happens.
From other reading, I assume the Property RowSource input is an Initialise event but this doesn't help me much and I need to concatenate two sources into the single ComboBox. I will also need to make subsequent ComboBoxes dynamic so I could really use a few pointers as how to get past the first hurdle.
I expect I'm doing something daft, but any help would be welcomed.