View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati[_2_] Vasant Nanavati[_2_] is offline
external usenet poster
 
Posts: 45
Default Clearing list from all form commandboxes

Hi Josh:

What is a "commandbox"?

If you mean ComboBoxes:

Sheet1.ComboBox1.Clear
Sheet1.ComboBox2.Clear

etc.

You cannot clear ComboBoxes in this fashion if they are populated via a
RowSource.

Regards,

Vasant.



"josh ashcraft" wrote in message
...
attn: Tom Oglivy or anyone else who may be able to help...

I need help Clearing the list from all form commandboxes
on my worksheet, the code I had earlier didn't seem to
work correctly, or I was using it wrong, could someone
please help me with this?
Thanks in advance,
Josh