View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
 
Posts: 226
Default CombBox - Object of What Collection?

Depends on the toolbar that you used. But, assuming that you're using the
Control Toolbox, then its usually something like

Dim Ctl As MSForms.Control
For Each Ctl In Me.Controls
If TypeName(Ctl) = "ComboBox" Then
'Stuff here
End If
Next Ctl

Regards,

Juan Pablo González

"George" wrote in message
...
What Collection are ComboBoxes objects of? So that they can be accessed to

perfom a modification on each ComboBox in the application via a For Each
Next loop?