| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I use checkbox thus I could calculate the value in a sheet
How can I use the component checkBox in my sheet and after user check/uncheck
this component I will calculate the value according to the formula I have |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
can I use checkbox thus I could calculate the value in a sheet
Perhaps link the checkbox to a cell, then use a reference to that cell in
your formula. Right click on the checkbox and select Properties, then use the linked cell property. Sheet1!A1 as an example. -- Regards, Tom Ogilvy "calculate checkBox value in a sheet" wrote: How can I use the component checkBox in my sheet and after user check/uncheck this component I will calculate the value according to the formula I have |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ASSIGN VALUE TO CHECKBOX AND CALCULATE AVERAGE? | New Users to Excel | |||
| checkbox, then taking information from one sheet to another sheet | Excel Worksheet Functions | |||
| copy if checkbox checked to sheet two | Excel Programming | |||
| checkbox on form reset from checkbox on sheet | Excel Programming | |||
| copy checkbox name into sheet. | Excel Programming | |||
Linear Mode
