JKwan
10-30-2009, 08:47 AM
I have n number of checkboxes on my spreadsheet. How do I get the state of each checkboxes? I used the SHAPES.COUNT to get the number of checkboxes, but then I got stuck in getting the state of the checkbox. This is what I have so far but I am really stuck
For Index = 1 To Sheet1.Shapes.Count
If Left(Sheet1.Shapes.Item(Index).Name, 8) = "CheckBox" Then
End If
Next
I did try using Sheet1.Checkbox1.Value, this gave me the state of CheckBox1, but I have n number of checkboxes.....
Thanks
For Index = 1 To Sheet1.Shapes.Count
If Left(Sheet1.Shapes.Item(Index).Name, 8) = "CheckBox" Then
End If
Next
I did try using Sheet1.Checkbox1.Value, this gave me the state of CheckBox1, but I have n number of checkboxes.....
Thanks