Userform Combo box needs a variable row source.

[braindiesel]

Hello,

I have a userform (called "adjustprod")
On it I have a combobox called "adjustbox"
The row source is a range called adjustProdList1, adjustProdList2 or adjustProdList3 depending if you launch the box from my year 1, year 2 or Year 3 sheet.
In cell A1 on each of the sheets is a 1, 2, or 3 respectively

Is there a way I can have the variable row source or do I need three userforms?

If so do I put the code in immediately before the launch, as I have tried below (which yields an error) or is there somewhere I put is for when I launch the userform?

adjustBox.RowSource = Range("adjustProdList" & Range("a1").Value).Address
AdjustProd.Show

 

[pedie]

[/FONT]
[FONT=Courier New]you launch the box from my year 1, year 2 or Year 3 sheet.[/FONT]
[FONT=Courier New]In cell A1 on each of the sheets is a 1, 2, or 3 respectively[/FONT]
[FONT=Courier New]

What is this 1, 2 and 3? is this a button? how does your form show?

 

[AlphaFrog]

Your code worked for me.

adjustBox.RowSource = Range("adjustProdList" & Range("a1").Value).Address

What error do you get?

 

[braindiesel]

I'm getting a runtime error 424

if the code is working, then the problem must be where I am supposed to put it.

Do I declare the source BEFORE I show the userform?
or
if not, how do I get the source to be declared upon launching the form?

 

[AlphaFrog]

Your combobox is not named adjustBox

Or you might have to reference the userform...
adjustprod.adjustBox.RowSource = Range("adjustProdList" & Range("a1").Value).Address

 

[braindiesel]

It was the userform name missing.

Thanks for the help