Dave Peterson posted some code that links the check box to the cell at
its top left:
http://groups.google.com/groups?&thr...351B%40msn.com
Jonathan wrote:
I have check boxs in 1800 rows, they should be linked to seperate cells in each row IE d21 when the check box is checked d21 returns a value of true. now i copied and pasted the check boxs but all 1800 refered back to d21 is there a way to change the cell reference without going into the format control box and changing all 1800 of them to read d22, d23 etc.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html