Check boxes sit on top of the worksheet an cannot directly effect
functions on the worksheet. You need to set the Linked Cell property of
the check box to add either True or False to a new column in the
worksheet. So if you put a true or false in colmn b then modify you
formula as follows

from
ActiveCell.FormulaR1C1 =
"=RC[60]+RC[90]+RC[102]+RC[114]+RC[126]-RC[108]"

to
ActiveCell.FormulaR1C1 =
"=if(RC[2]=True,RC[60]+RC[90]+RC[102]+RC[114]+RC[126]-RC[108],0)"


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=183466

Microsoft Office Help