ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I need to create a simple checkbox that has true false outputs (https://www.excelbanter.com/excel-discussion-misc-queries/92449-i-need-create-simple-checkbox-has-true-false-outputs.html)

RCN

I need to create a simple checkbox that has true false outputs
 


Debra Dalgleish

I need to create a simple checkbox that has true false outputs
 
You can use a check box from the forms toolbar:

Choose ViewToolbarsForms
Click on the Check box tool, to select it
Click on the worksheet, where you want the checkbox
With the check box selected, choose FormatControl
On the Control tab, enter a cell address in the Cell Link box
Click on the worksheet, away from the check box, to deselect it
Click on the check box, and a TRUE will appear in the linked cell

RCN wrote:

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 03:30 PM.

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