Create a Fuctioning Checkbox

  • Thread starter Thread starter Richard
  • Start date Start date
R

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.
 
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
 
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
 
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.
 
That worked. Thank you all for your assistance!

Peo Sjoblom said:
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
Click to expand...
 
Back
Top