You could link the checkbox to a cell, and then pick up that linked cell in
your formula.

Linking a cell is a checkbox property, set it in design mode.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bizechick" wrote in message
...

Hello...

I am new to macros so please forgive me if I don't explain this
clearly. I have a check box. When it is checked I need the formula in
another cell to recognize that it is checked and calculate the formula.
Can anyone help me with this?

Thanks!


--
bizechick
------------------------------------------------------------------------
bizechick's Profile:
http://www.excelforum.com/member.php...o&userid=16408
View this thread: http://www.excelforum.com/showthread...hreadid=277787