I am having trouble renaming check boxes. I am working in the developers tab and click on design mode. Next I grab the check box by clicking the right mouse button so all 4 sides are selected. With my cursor in the name box, I replace the old name (check
box 15) with the new name (check box 4) and hit enter. The new name (check box 4) disappears THe box is no longer selected and the name (check box 3) appears. I then reselect the check box I am trying to rename. THe original name (check 15) is still there.
Should be simple shouldn't it? What am I doing wrong.
If the current name is really something like "Check Box 15" with spaces, the control must be a Forms check box, not an ActiveX check box, so Design Mode isn't relevant.
If renaming doesn't work, there probably already was a check box named "Check Box 4". So try another name.
Another way of renaming a Forms control:
Right-click on the control to select it.
Press Alt+F11 to activate the Visual Basic Editor.
Press Ctrl+G to activate the Immediate window.
Type a line like the following:
Selection.Name = "Check Box 4"
With the insertion point anywhere in that line, press Enter.
Switch back to Excel. You will probably still see the old name.
Deselect, then reselect the control. You should now see the new name.
--- Best wishes, HansV https://www.eileenslounge.com
14 people found this reply helpful
·
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
