I want to add a checkbox into my spreadsheet. What is the best way to do that?

Once that is done, what should I do to set it up to be referred to in
another area, such as a formula?

Thank you.

If you add it from the forms toolbar, drag it down from the toolbar, and go
into properties and link it to a cell. You can then test this cell for True
or False in your formula.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bryan Bloom" wrote in message
...
I want to add a checkbox into my spreadsheet. What is the best way to do
that?

Once that is done, what should I do to set it up to be referred to in
another area, such as a formula?

Thank you.

Use the Control Toolbox from the Toolbars menu...View-Toolbars-Control
Toolbox.
Create your checkbox from this toolbar. Then right click the checkbox and
select Properties. Set the LinkedCell option to the desired cell in your
worksheet. When checked, your linked cell will display "TRUE", otherwise
"FALSE".

HTH,
Paul

"Bryan Bloom" wrote in message
...
I want to add a checkbox into my spreadsheet. What is the best way to do
that?

Once that is done, what should I do to set it up to be referred to in
another area, such as a formula?

Thank you.

Thank you to both of you, it works perfectly!!!!!

Bryan

"PCLIVE" wrote:

Use the Control Toolbox from the Toolbars menu...View-Toolbars-Control
Toolbox.
Create your checkbox from this toolbar. Then right click the checkbox and
select Properties. Set the LinkedCell option to the desired cell in your
worksheet. When checked, your linked cell will display "TRUE", otherwise
"FALSE".

HTH,
Paul

"Bryan Bloom" wrote in message
...
I want to add a checkbox into my spreadsheet. What is the best way to do
that?

Once that is done, what should I do to set it up to be referred to in
another area, such as a formula?

Thank you.