Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using quite a few Check Boxes on an input page for my co-workers. When
I right-click the first CB, "Check Box 1" appears left of the Formula Bar. I can also manipulate this CB in VBA using "ActiveSheet.Shapes(1).". This also works for CB 2 and CB 3. However, when I right click the CB which VBA knows as Shape(4), "Check Box 19" appears left of the Formula Bar. I want "Check Box X" to coordinate with Shape(X) so I know what I am going to be changing in VBA. Is there a way to do that? Yesterday, when I clicked Shape(3), it was labelled as "Check Box 4". I clicked on that entry and changed the "4" to "3", so now Shape(3) has at least two names. When I attempt to change "Check Box 19" (which is Shape(4)) to "4", Shape(3) is selected. I hope it didn't get too confusing. -- Brad E. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
all the check boxes should be checked if i check a particular checkbox in that row | Excel Programming | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |