hide all comboboxes

  • Thread starter Thread starter sunilpatel
  • Start date Start date
S

sunilpatel

Hi

i would like to hide all comboboxes on a particular sheet without knowing
all their names

is this possible?

Thanks
 
Option Explicit
Sub testme()
Dim OLEObj As OLEObject
For Each OLEObj In ActiveSheet.OLEObjects
If TypeOf OLEObj.Object Is MSForms.ComboBox Then
OLEObj.Visible = False
End If
Next OLEObj
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox Population 6
Autofilter by combobox selection 1
Combobox selection 1
Cut and paste with a combobox 0
Hide Rows based on Combobox Selection 15
RowSource as Sheet Names in UserForm ComboBox 1
Combobox filtering 2
Iterating through a ComboBox's values 6

Back
Top