ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I add a interative checkbox? (https://www.excelbanter.com/excel-discussion-misc-queries/198135-how-do-i-add-interative-checkbox.html)

Noshin

How do I add a interative checkbox?
 
How do I add an interactive checkbox which I can click and unclick?

Bob I

How do I add a interative checkbox?
 
Developer Tab, Insert, pick the checkbox.

Noshin wrote:

How do I add an interactive checkbox which I can click and unclick?



M Kan

How do I add a interative checkbox?
 
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

--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Noshin" wrote:

How do I add an interactive checkbox which I can click and unclick?


AKphidelt

How do I add a interative checkbox?
 
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.

"Noshin" wrote:

How do I add an interactive checkbox which I can click and unclick?


Noshin

How do I add a interative checkbox?
 
Thanks guys! Your answers helped :)

"Noshin" wrote:

How do I add an interactive checkbox which I can click and unclick?



All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com