checkbox event handling function

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)

"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
---

Hi!

Link the checkbox to a cell then refer to that cell:

Linked cell = A1

=IF(A1,L49 + (L49 * F41 / 100),0)

Or:

=IF(A1=TRUE,L49 + (L49 * F41 / 100),0)

It looks like you're using a ckbx from the control toolbox so open the
control toolbox. Enter design mode. Right click on the ckbx and select
Properties. Find LinkedCell and enter the cell you want to link to this
ckbx, in this example, A1. Close the Properties dialog, exit design mode,
close the control toolbox.

Biff

"nevwalters" <nevwalters@discussions.microsoft.com> wrote in message
news:8EC3C4E4-37C7-4D1A-A3B1-62BDE6617E47@microsoft.com...
> 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)