Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is checkbox is checked?
Is there an "if" statement to see if checkbox is checked or not
|
#2
|
|||
|
|||
Is checkbox is checked?
The checkbox should be "linked" to a cell - that cell will either be true or
false. Right/click the checkbox, select Format Control, click i the Cell link refedit box, then click a cell to represent the cb's state. Bob Umlas Excel MVP "Fred S" <Fred wrote in message ... Is there an "if" statement to see if checkbox is checked or not |
#3
|
|||
|
|||
Is checkbox is checked?
If you link the checkbox to a cell and use default when checked the cell
will display TRUE else FALSE, If you want for instance get a yes or no from that? Assume you link the check box to a cell hidden or not in view, let's say IV1, then you could in the cell next to the check box have a formula like =IF(IV1,"Yes","No") to link a checkbox from the forms toolbar, right click and select format control from the control toolbox, right click and select properties and find linked cell -- Regards, Peo Sjoblom (No private emails please) "Fred S" <Fred wrote in message ... Is there an "if" statement to see if checkbox is checked or not |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox | Excel Discussion (Misc queries) | |||
print checkbox | Excel Discussion (Misc queries) | |||
Check boxes - when one box is checked, I want a 2nd box to auto ch | Excel Discussion (Misc queries) | |||
set checkbox to enter date when checked and NOT recalculate | Excel Worksheet Functions | |||
copy many CHECKBOX | Excel Discussion (Misc queries) |