| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 97 VBA: Binding a combo to a named range
In the past when using combo boxes I've added items to
them using the add method. I'd like to reference a named range from a separate stand alone spreadsheet, so that I can provide a combobox that has values that can be maintained separately. I can't work out how one binds a combo in this way? Can anyone help? Many thanks David |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97 VBA: Binding a combo to a named range
Hi David:
Just right-click on the ComboBox to access its properties, and then set the RowSource (or ListFillRange) property to the string rpresenting the source range address. Or, in code: ComboBox1.RowSource = "Sheet2!A1:A10" Regards, Vasant. "David" wrote in message ... In the past when using combo boxes I've added items to them using the add method. I'd like to reference a named range from a separate stand alone spreadsheet, so that I can provide a combobox that has values that can be maintained separately. I can't work out how one binds a combo in this way? Can anyone help? Many thanks David |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97 VBA: Binding a combo to a named range
Thanks very much Vasant.
I can get that to work but I was trying to reference a named range. This is what I've got but it doesn't work: ComboBox1.RowSource = Range("test") "test" is the name of a range in the current book. Ideally I would like to reference a range in a separate standalone book. -----Original Message----- Hi David: Just right-click on the ComboBox to access its properties, and then set the RowSource (or ListFillRange) property to the string rpresenting the source range address. Or, in code: ComboBox1.RowSource = "Sheet2!A1:A10" Regards, Vasant. "David" wrote in message ... In the past when using combo boxes I've added items to them using the add method. I'd like to reference a named range from a separate stand alone spreadsheet, so that I can provide a combobox that has values that can be maintained separately. I can't work out how one binds a combo in this way? Can anyone help? Many thanks David . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97 VBA: Binding a combo to a named range
David,
Need to use a String ComboBox1.RowSource = Range("test").Address May need to qualify the worksheet ComboBox1.RowSource = Sheets("Sheet1").Range("test").Address -- sb "David" wrote in message ... Thanks very much Vasant. I can get that to work but I was trying to reference a named range. This is what I've got but it doesn't work: ComboBox1.RowSource = Range("test") "test" is the name of a range in the current book. Ideally I would like to reference a range in a separate standalone book. -----Original Message----- Hi David: Just right-click on the ComboBox to access its properties, and then set the RowSource (or ListFillRange) property to the string rpresenting the source range address. Or, in code: ComboBox1.RowSource = "Sheet2!A1:A10" Regards, Vasant. "David" wrote in message ... In the past when using combo boxes I've added items to them using the add method. I'd like to reference a named range from a separate stand alone spreadsheet, so that I can provide a combobox that has values that can be maintained separately. I can't work out how one binds a combo in this way? Can anyone help? Many thanks David . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97 VBA: Binding a combo to a named range
ComboBox1.RowSource = Sheets("Sheet1").Range("test").Address(external:=t rue)
Will include the worksheet name in the string. (along with the workbook name, too.) steve wrote: David, Need to use a String ComboBox1.RowSource = Range("test").Address May need to qualify the worksheet ComboBox1.RowSource = Sheets("Sheet1").Range("test").Address -- sb "David" wrote in message ... Thanks very much Vasant. I can get that to work but I was trying to reference a named range. This is what I've got but it doesn't work: ComboBox1.RowSource = Range("test") "test" is the name of a range in the current book. Ideally I would like to reference a range in a separate standalone book. -----Original Message----- Hi David: Just right-click on the ComboBox to access its properties, and then set the RowSource (or ListFillRange) property to the string rpresenting the source range address. Or, in code: ComboBox1.RowSource = "Sheet2!A1:A10" Regards, Vasant. "David" wrote in message ... In the past when using combo boxes I've added items to them using the add method. I'd like to reference a named range from a separate stand alone spreadsheet, so that I can provide a combobox that has values that can be maintained separately. I can't work out how one binds a combo in this way? Can anyone help? Many thanks David . -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97 VBA: Binding a combo to a named range
Thanks very much guys
"Dave Peterson" wrote in message ... ComboBox1.RowSource = Sheets("Sheet1").Range("test").Address(external:=t rue) Will include the worksheet name in the string. (along with the workbook name, too.) steve wrote: David, Need to use a String ComboBox1.RowSource = Range("test").Address May need to qualify the worksheet ComboBox1.RowSource = Sheets("Sheet1").Range("test").Address -- sb "David" wrote in message ... Thanks very much Vasant. I can get that to work but I was trying to reference a named range. This is what I've got but it doesn't work: ComboBox1.RowSource = Range("test") "test" is the name of a range in the current book. Ideally I would like to reference a range in a separate standalone book. -----Original Message----- Hi David: Just right-click on the ComboBox to access its properties, and then set the RowSource (or ListFillRange) property to the string rpresenting the source range address. Or, in code: ComboBox1.RowSource = "Sheet2!A1:A10" Regards, Vasant. "David" wrote in message ... In the past when using combo boxes I've added items to them using the add method. I'd like to reference a named range from a separate stand alone spreadsheet, so that I can provide a combobox that has values that can be maintained separately. I can't work out how one binds a combo in this way? Can anyone help? Many thanks David . -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation Combo box using Named Ranges | Excel Discussion (Misc queries) | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| combo box named range | Excel Discussion (Misc queries) | |||
| Paste a named range to another range in Excel | Excel Discussion (Misc queries) | |||
| DAO objects with late binding in Excel? | Excel Programming | |||
Hybrid Mode
