looping shapes

B

bg18461

how would you put this line of code in a for loop for shapes (saying
have 10 form check boxes), ex:

For i = 1 To 10
Sheets("Sheet1").Shapes("Check Box" & i).Visible = True
next i

I know this will not work, so how can i write the code to make it work
 
D

Dave Peterson

Oops.

For i = 1 To 10
Sheets("Sheet1").Shapes("Check Box " & i).Visible = True
Next i

If you haven't renamed the checkboxes, there's a space between the number and
the last X.

"Check Box 9"
for instance.
 
Top