If you are using a Form control, then you should be able to right mouse
click on the checkbox, select Format control and when the format box
appears, select the Control tab. There is a section there to link the
form to a cell.

If you are using an ActiveX control, you need to be in Design Mode to
change the link. Go to View/Toolbars/Visual Basic and select it.
There if you put your mouse pointer over each of the toolbar options,
one will be Design Mode. Select this. When you right mouse click on
your control, the menu should show Properties, View Code etc... Go to
properties and in the Linked Cell option, change the cell reference
manually. You can not select the cell using your mouse pointer. When
you are done making your edits, select the Design Mode icon again to
make the control active.


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=466935