Create a Fuctioning Checkbox

[Richard]

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.

 

[FSt1]

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

 

[Peo Sjoblom]

View>toolbars>forms, 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

 

[Cordell]

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.

 

[Richard]

That worked. Thank you all for your assistance!

View>toolbars>forms, 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