View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
the00snoopy the00snoopy is offline
external usenet poster
 
Posts: 4
Default Cycle through all Checkboxes on a worksheet

I would like to create a macro that will find all the checkbox controls (they
are all directX) on a worksheet and then check each one. If it is checked, I
would like it to run a macro with a name identical to the caption on the
checkbox.

How would I go about searching for checkboxes and compsosing a list of them?