Go into Design mode, right click on your check box and open properties.
Enter a cell in LinkedCell field, A1 for example
Now put this in your formula:
=IF(A1=True, V35, 0)
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile:
http://www.excelforum.com/member.php...o&userid=35016
View this thread:
http://www.excelforum.com/showthread...hreadid=554352