checkbox event handling function

N

nevwalters

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)
 
M

Max

nevwalters said:
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)
Click to expand...

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)
 
B

Biff

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
 
Top