Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding a Combo Box.
Hi all,
I attempting to hide a combo box control that is created directly from the "Control Toolbox." This particular ComboBox is embedded within Sheet1, not a userform. The value of checkbox must be unchecked or false in order for combo box to be hidden. (Excel 2000) The property I have been trying to attempt this with the ComboBox .Visible property. So far this hasn't been successful. Here is a sample of what I have done. Sub Checkbox_data_source_information_type_of_email() With Worksheets("Sheet1") .OLEObjects("cboComboBox1").Object _ .Visible = False .OLEObjects("cboComboBox2").Object .Visible = False End With The error I get is the Property doesn't support this method (Run time #438.) Any help you could give would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
2 questions one on list/combo boxes and the other on "atomically" hiding columns or rows. | New Users to Excel | |||
"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) | |||
Problem hiding/unhiding columns using combo control | Excel Programming |