| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing CheckBox Control Names
I have a sheet that contains 180 checkboxes  in a 20 x 9 grid.The names of those checkboxes are all over the place, and I want the names for the first row of boxes to be CheckBox 10, CheckBox 11... CheckBox 18. Next Row is CheckBox 20, CheckBox 21... And so on... I can change the name by using the name box, but with so many, it would be much easier to use a macro. I think using a loop, with a SendKeys("{TAB"}) will work, but I can't seem to find the code that will change the name.  :( Someone help! Thanks in advance. -- grime ------------------------------------------------------------------------ grime's Profile: http://www.excelforum.com/member.php...o&userid=19227 View this thread: http://www.excelforum.com/showthread...hreadid=479510 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem with checkbox control | Excel Worksheet Functions | |||
| how do I protect a worksheet and still use a checkbox control | Excel Worksheet Functions | |||
| Checkbox control | Excel Programming | |||
| enlarge built-in checkbox control | Excel Programming | |||
| VBA Control Checkbox | Excel Programming | |||
![grime[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
