"nevwalters" wrote:
how to get a cell to handle a checkbox event to do a function/calculation
using other cell data? Have tried this code in cell, =IF(CheckBox2_Click() =
TRUE,L49 + (L49 * F41 / 100),0)

Assuming it's a forms checkbox,

Right-click on the checkbox Format Control
Enter as the Cell Link: X49 (say), click OK

Then we could put in say, M49:
=IF(X49, L49 + (L49 * F41 / 100),0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---