Learning Macros and ActiveX controls...have a simple question...

[bizechick]

Hello...

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

Thanks

 

[Bob Phillips]

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)