userform syntax

[Guest]

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

 

[papou]

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

HTH
Cordially
Pascal

 

[Guest]

Try:

For Each ComboBox In UserForm1
.Clear
Next