N
Noshin
How do I add an interactive checkbox which I can click and unclick?
B
Bob I
Developer Tab, Insert, pick the checkbox.
M
M Kan
Go View: Toolbars: Forms Tools. There is a check box option there that will
output a true or false depending on the state
http://www.kan.org/tips/excel_forms_tools.php
output a true or false depending on the state
http://www.kan.org/tips/excel_forms_tools.php
A
akphidelt
Not sure what version of Excel you use, but in 2003 you can go to
View->Toolbars->Forms
Click on your checkbox
Now right click on it, and go to format control.
Click in to the "cell link" box and then click a random spot on your excel
spreadsheet.
Now do a little test and click and unclick the checkbox. You should be able
to develop your formulas from there.
View->Toolbars->Forms
Click on your checkbox
Now right click on it, and go to format control.
Click in to the "cell link" box and then click a random spot on your excel
spreadsheet.
Now do a little test and click and unclick the checkbox. You should be able
to develop your formulas from there.
N
Noshin
Thanks guys! Your answers helped 