userform syntax
 

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

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

userform syntax
 

Try:

For Each ComboBox In UserForm1
.Clear
Next



"Newbie" wrote:

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