Hello,
This code to uncheck a forms control checkbox works when the checkbox exists by itself on the worksheet.
But how do you refer to the checkbox when the checkbox is grouped with other checkboxes and textboxes? These do not work:
Please Login or Register to view this content.
Please Login or Register to view this content.thanksPlease Login or Register to view this content.
Hello tmallin,
When Shapes are grouped together, a new invisible Shape is created that contains the other Shapes. These new Shapes
are named Group 1, Group 2, etc.
Once you know the name of the Group, you can reference a Shape in the Group like this:
Please Login or Register to view this content.
This macro will list the names of Shapes in all Groups on the Active Sheet.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
That's the syntax I was looking for. Thanks, Leith
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks