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