looping shapes

[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

 

[Dave Peterson]

One from yesterday.
http://groups.google.com/[email protected]

 

[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.

 

[Dave Peterson]

Hey!

Yesterday's post had that extra space in it!

 

[bg18461]

Thanks, so much