How to change check box name using mouse and keyboard
I have a chart with many forms controls on it (check boxes). I need to change
the names of some of check boxes from system assigned "Check box nn" to more
meaningful, like "cbBrightness". I know I can write a macro which will do the
trick for me:
ActiveSheet.Shapes("Check Box 19").Select
Selection.Name = "cb75GlMag"
will change name of box "Check Box 19" to "cb75GlMag"
two problems:
1) After some tweaking I ended up with two check boxes with the same name
(cbDuplicatename) so my code gets confused and does not work. I need to
change the name manually, using mouse and keyboard.
2) I just need to learn how to change control properties manually. I believe
I knew it at some point but now it just hitting a black spot in my head
(where others have brain). I know it is not a right way to use macro for such
change...
Patient guidance is very much appreciated...
|