LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding a button when hiding rows fergusor Excel Discussion (Misc queries) 2 August 10th 06 02:31 PM
2 questions one on list/combo boxes and the other on "atomically" hiding columns or rows. Marc New Users to Excel 1 March 4th 06 05:13 AM
"Combo Box - getting control combo box to stick in place in worksh ajr Excel Discussion (Misc queries) 1 February 16th 05 02:05 AM
"Combo Box - getting control combo box to stick in place in worksh ajr Excel Discussion (Misc queries) 0 February 15th 05 07:45 PM
Problem hiding/unhiding columns using combo control olivier durand Excel Programming 2 October 28th 03 03:07 PM


All times are GMT +1. The time now is 09:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"