| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combo Box to populate variable output range | Excel Discussion (Misc queries) | |||
| combo box range - row | Excel Discussion (Misc queries) | |||
| Variable Input Range for Combo Box | Excel Worksheet Functions | |||
| combo box named range | Excel Discussion (Misc queries) | |||
| Refer to Combo-box using a part + variable | Excel Programming | |||
![Bob Phillips[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
