Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unset shape checkboxes with VBA
Hi NG,
I've got about 60 checkboxes on my spreadsheet (not in a user form!) and I'd like to unset these checkboxes with VBA. So far I've come up with the following: Dim c As Shape For Each c In ActiveSheet.Shapes If Left(c.Name, 8) = "CheckBox" Then ActiveSheets.Shapes.Object.Value = 0 End If Next c However, I cannot change the value, i.e. whether or not the checkboxes are set or not. How do I address these shapes/checkboxes and set them to unchecked? -- Andreas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add and edit a shape in VBA | Excel Discussion (Misc queries) | |||
Specify shape dimensions | Excel Discussion (Misc queries) | |||
Shape coordinates | Excel Discussion (Misc queries) | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Automatique Shape | Excel Discussion (Misc queries) |