Thread: userform syntax
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
papou[_9_] papou[_9_] is offline
external usenet poster
 
Posts: 52
Default userform syntax

For Each cb in UserForm1.Controls
If TypeOf cb Is MSForms.Combobox Then cb.Value = ""
Next cb

HTH
Cordially
Pascal

"Newbie" a écrit dans le message de
...
I'm trying to clear all comboboxes in one hit.

For Each ComboBox In UserForm1
.Value = ""
Next

.. would be great - if it worked!
Can someone please help me wit h the syntax?
TIA