Nedd help with the simplest thing with the check box

[Zubbus]

I'm trying to do the simplest thing (and have wanted to for years) with
a check box - stick it -in- a cell just so I can check or uncheck it.
Of course, it will be even better if I can get the rest of the
worksheet to read a 1/0 or true/false from this box; but I'm using
office 2000 and it says nothing useful. I pull the box out of the form
toolbar, but it's a floating object like a chart. And that's all the
reference I can find in Officer 2000.

Thanks in advance for any help you can give.

 

[Haldun Alay]

Make visible Control Toolbox from toolbars. Add a checkbox to your worksheet and select the checkbox and press Properties button in Control Toolbox toolbar. Enter Cell reference (where you want to store checkbox's state) to LinkedCell in properties window.
Possible LinkedCell values samples (A1 or Sheet1!A1 or 'Annual Income'!A1).

Then press Quit Design Mode in Control Toolbox toolbar.


Now when you check or uncheck the checkbox, You'll see LinkedCell content changed to True (checked) or False (unchecked).


--
Haldun Alay
"Zubbus" <[email protected]>, haber iletisinde þunlarý yazdý:[email protected]...

I'm trying to do the simplest thing (and have wanted to for years) with
a check box - stick it -in- a cell just so I can check or uncheck it.
Of course, it will be even better if I can get the rest of the
worksheet to read a 1/0 or true/false from this box; but I'm using
office 2000 and it says nothing useful. I pull the box out of the form
toolbar, but it's a floating object like a chart. And that's all the
reference I can find in Officer 2000.

Thanks in advance for any help you can give.

 

[Dave Peterson]

You can still use that checkbox from the Forms toolbar.

Right click on it and choose "format control"
Then on the control tab, use the cell link.

Then you can use that cell in your formulas--it'll show true or false.

If you have lots of these checkboxes, you can put all the linked cells in a
column and hide that column.

Or you could format those cells with a custom format of:
;;;
(3 semicolons)
and the cell will look empty--but you can still see the value in the formula bar
(and use it in other formulas)