Thread: Check Boxes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OMG OMG is offline
external usenet poster
 
Posts: 1
Default Check Boxes

I've placed several check boxes in a worksheet (not on a form). What I want to do through VBA is to iterate through all the check boxes and, where the "Value" property returns True then read the caption. My problem is that I can't figure out how to iterate through the boxes efficiently. With the worksheet name of "Parameters" I've tried "Parameters.CheckBox1.Value" but I want to be able to just get a collection of all checkboxes on the page and iterate

Any ideas