VBA for changing the RowSource Range on a ComboBox Excel 2010

[Maccus77]

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.

 

[Mohammad Basem]

Hi Maccus77,

Try,

[FONT="Consolas"][SIZE="2"][COLOR="Navy"]UserForm.ComboBox.RowSource=Range("Lookup!RangeName").Address[/COLOR][/SIZE][/FONT]

 

[Maccus77]

Many thanks Mohammed. That works. Also, what I had not been doing was putting it in the UserForm Initialise part of the VBA.

 

[Mohammad Basem]

Most welcome and thank you for the feedback!