Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Most efficient method in Excel? Mouse or Keyboard keys? | Excel Discussion (Misc queries) | |||
How can I use the mouse or keyboard to zoom in Excel? | Excel Discussion (Misc queries) | |||
Mouse pointer change | Excel Discussion (Misc queries) | |||
check marks in excel cells using your mouse | Excel Worksheet Functions | |||
How can I access formula bar by using keyboard not mouse? | New Users to Excel |