Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add to Combo Control from referenced worksheet object
I have a workbook that contains a worksheet named "Sheet1"
on that worksheet I have a combo box (type: control toolbar) . I have a little procedure that adds values to the combo box. When I refer to the combo box as thisworkbook.worksheets("Sheet1").combobox1.AddIte m i or for that matter wkb.worksheets("Sheet1").comboBox1.Additem i it works fine. However when I create a reference to a worksheet object in thisworkbook Such as: set wkb = thisworkbook set wks = wkb.worksheets("Sheet1") wks.ComboBox1.AddItem i and add an item, I get an error message. Does anyone know why that is? Thanks, Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Place a Drawing Object on a Worksheet as a Control? | Excel Programming | |||
I've started designing a combo box and have the look up cells referenced. | New Users to Excel | |||
Combo Boxes built with Control Toolbox on a Worksheet | Excel Programming | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |