Nedd help with the simplest thing with the check box

Z

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.
 
D

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)
 
Top