View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Theresa[_5_] Theresa[_5_] is offline
external usenet poster
 
Posts: 1
Default Looping checkboxes embedded in worksheet

Hello!

I'm new to programming in excel, so I'm hoping this is an "easy"
question. I have a worksheet with several checkboxes (from control
toolbox) and I want to loop through these and check if they are true
or false which then triggers more code. If their names a box1,
box2, etc. can I use the loop to increment the 1, 2, 3.... Something
like:

for i = 1 to 10
if CheckBox & i. value = True then
code here
end if
next i

Thanks in advance for any help!

Theresa