How to add a variable in a range for a Combo Box
 

Kali,

Too many quotes

ComboBox1.RowSource = ("D3:D" & totalRow)


--

HTH

Bob Phillips

"Kali" wrote in message
...
I have a user form with a combo box, and I am populating
it with Excel cells, but as I will use different
worksheets, the range will change.

For example: I have
ComboBox1.RowSource = ("D3:D100")

And I want to put somrthing like
ComboBox1.RowSource = ("D3:D" & totalRow")

But I don't know the syntax to put the variable in there.
All help will be apreciated!

How to add a variable in a range for a Combo Box
 

Thank you, Bob and Tom!
Kali.


-----Original Message-----
Kali,

Too many quotes

ComboBox1.RowSource = ("D3:D" & totalRow)


--

HTH

Bob Phillips

"Kali" wrote in message
...
I have a user form with a combo box, and I am
populating
it with Excel cells, but as I will use different
worksheets, the range will change.

For example: I have
ComboBox1.RowSource = ("D3:D100")

And I want to put somrthing like
ComboBox1.RowSource = ("D3:D" & totalRow")

But I don't know the syntax to put the variable in
there.
All help will be apreciated!


.