Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a ComboBox control from a Workbook Object?
Hi Everybody,
I have a ComboBox control on a Worksheet. From the code behind of the Worksheet I am able reference it and alter it's properties i.e. MyComboBox.Text = "Hello" My goal is to reference that same control from the code behind of the Workbook instead? i.e. ThisWorkbook.Worksheets("Sheet1"). ? Thanks for any help! Sam P.S. ThisWorkbook.Worksheets("Sheet1").MyComboBox.Text doesn't work? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
form control combobox | Excel Discussion (Misc queries) | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
Control ToolBox ComboBox | Excel Discussion (Misc queries) | |||
HELP PLEASE..Inserting combobox (ActiveX control) makes workbook c | Excel Discussion (Misc queries) | |||
How to pass valve in combobox object to cell | Excel Programming |