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
|