Hiding a Combo Box.
 

Or you might need to reference the sheet, if you are coming from a form

e.g.

Sheets(1).cboLotusNotesFoldersDocuments.Visible +AD0- False


+ACI-Mike Tomasura+ACI- +ADw-MTomasura+AF8-nospam+AEA-bradleycaldwell.com+AD4- wrote in message
news:OJaUtb+ACQ-nDHA.684+AEA-TK2MSFTNGP09.phx.gbl...
If you are still in design mode you will see the object.
Try to exit design mode.



+ACI-cwsax+ACI- +ADw-anonymous+AEA-discussions.microsoft.com+AD4- wrote in message
news:01d201c39ff6+ACQ-08a1ab90+ACQ-a501280a+AEA-phx.gbl...
+AD4- I think I have tried this but to no avail. I think my
+AD4- main issue is refering back to the combobox within the
+AD4- sheet in VBA. In other words how do you refer to a named
+AD4- combo box e.g. (cboLotusNotesFoldersDocuments). Everytime
+AD4- I refer to this name I am told the variable is not defined
+AD4- and when I setup a Dim cboLotusNotesFoldersDocuments as
+AD4- CombBox I still can't set the Visible property to False.
+AD4-
+AD4- Thanks I am very frustrated with the Excel Object Model
+AD4- right now since I am a novice. Thanks.
+AD4-
+AD4- +AD4------Original Message-----
+AD4- +AD4-Tey this
+AD4- +AD4-
+AD4- +AD4-ComboBox1.Visible +AD0- False
+AD4- +AD4-
+AD4- +AD4-
+AD4- +AD4AIg-cwsax+ACI- +ADw-anonymous+AEA-discussions.microsoft.com+AD4- wrote in
+AD4- message
+AD4- +AD4-news:02c001c39fee+ACQ-1ffb1f90+ACQ-a301280a+AEA-phx.gbl...
+AD4- +AD4APg- Hi all,
+AD4- +AD4APg-
+AD4- +AD4APg- I attempting to hide a combo box control that is created
+AD4- +AD4APg- directly from the +ACI-Control Toolbox.+ACI- This particular
+AD4- +AD4APg- ComboBox is embedded within Sheet1, not a userform. The
+AD4- +AD4APg- value of checkbox must be unchecked or false in order
+AD4- for
+AD4- +AD4APg- combo box to be hidden. (Excel 2000)
+AD4- +AD4APg-
+AD4- +AD4APg- The property I have been trying to attempt this with the
+AD4- +AD4APg- ComboBox .Visible property. So far this hasn't been
+AD4- +AD4APg- successful. Here is a sample of what I have done.
+AD4- +AD4APg-
+AD4- +AD4APg- Sub Checkbox+AF8-data+AF8-source+AF8-information+AF8-type+AF8-of+AF8-email()
+AD4- +AD4APg-
+AD4- +AD4APg- With Worksheets(+ACI-Sheet1+ACI-)
+AD4- +AD4APg- .OLEObjects(+ACI-cboComboBox1+ACI-).Object +AF8-
+AD4- +AD4APg- .Visible +AD0- False
+AD4- +AD4APg- .OLEObjects(+ACI-cboComboBox2+ACI-).Object
+AD4- +AD4APg- .Visible +AD0- False
+AD4- +AD4APg- End With
+AD4- +AD4APg-
+AD4- +AD4APg- The error I get is the Property doesn't support this
+AD4- +AD4APg- method (Run time +ACM-438.) Any help you could give would
+AD4- be
+AD4- +AD4APg- greatly appreciated.
+AD4- +AD4-
+AD4- +AD4-
+AD4- +AD4-.
+AD4- +AD4-