Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a Fuctioning Checkbox
I'd like to create a checkbox when checked returns a TRUE value and when
unchecked returns a FALSE value using Excel 2003? Any instruction would be appreciated. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a Fuctioning Checkbox
hi
a bit confused. true and false is the values retured by the check box. where are these values being returned to???? if you link a cells to the check box, the words true or false will appear in the cell depending of the state of the check box(check = true, uncheck = false) post back with more details. regards FSt1 "Richard" wrote: I'd like to create a checkbox when checked returns a TRUE value and when unchecked returns a FALSE value using Excel 2003? Any instruction would be appreciated. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a Fuctioning Checkbox
Viewtoolbarsforms, drag the check box to the sheet, right click and select
format control and then select a cell address for the link. -- Regards, Peo Sjoblom "Richard" wrote in message ... I'd like to create a checkbox when checked returns a TRUE value and when unchecked returns a FALSE value using Excel 2003? Any instruction would be appreciated. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a Fuctioning Checkbox
Tye the following steps:
1. Right mouse click in your toolbar area and enable the "Forms" toolbar 2. On the forms toolbar you'll see a checkbox, click it and then draw your check box 3. Right mouse click the newly created checkbox and on the Control tab, enter teh cell reference in the Cell Link box. When checked, that cell link will display TRUE or FALSE when unchecked. Also, you can change the text of the Check Box by right mouse clicking and editing the text. -- Cordell "Richard" wrote: I'd like to create a checkbox when checked returns a TRUE value and when unchecked returns a FALSE value using Excel 2003? Any instruction would be appreciated. Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a Fuctioning Checkbox
That worked. Thank you all for your assistance!
"Peo Sjoblom" wrote: Viewtoolbarsforms, drag the check box to the sheet, right click and select format control and then select a cell address for the link. -- Regards, Peo Sjoblom "Richard" wrote in message ... I'd like to create a checkbox when checked returns a TRUE value and when unchecked returns a FALSE value using Excel 2003? Any instruction would be appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create primary/secon single click checkbox line autopopulat | Excel Worksheet Functions | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
How do I create a checkbox in MS Excel? | Excel Discussion (Misc queries) | |||
I need to create a simple checkbox that has true false outputs | Excel Discussion (Misc queries) | |||
How can I make a checkbox create a value? | Excel Worksheet Functions |