Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checkbox event handling function
"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 --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checkbox event handling function
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" wrote in message ... 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way for excel to recognise that €0.00 = 0 for the purposes IF function ? | Excel Discussion (Misc queries) | |||
using a checkbox for a conditional function | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Event hundler to control the Excel function arguments | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |