Thread: userform syntax
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E AA2e72E is offline
external usenet poster
 
Posts: 400
Default 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