Check Boxes and Radio buttons on Worksheet

R

Ruth

I just discovered that I can drop check box directly on a worksheet. I can
make it do what I want, in a single instance, but I was wondering there was
a way to make them act like formulas, in that I would like to attach the
checkbox directly to a cell physically, and, incorporate it's TRUE/FALSE
output in a formula, then be able to copy a whole row or column of cells
containing the checkbox and formula ...and other data perhaps in a very
general way. in other words havethe control behave as if it were the
contents of a cell...Make sense? I don't want to have to write code or
fiddle with the properties of every single control I create, I want to
create a single prototype as it were and use it as the need arises...

Thanks
 
R

Ruth

Like Columbo..just one more question sir...if you don't mind...
In my search for help on this I realized I should make clear that it is
Excel controls I'm talking about here, not Activex although I will happily
use activex if this does the job for me...
 
D

Dave Peterson

If you rightclick on the checkbox, you can choose properties.

then choose Format control
then on the control tab, you can assign a cell link that will return true/false.

I sometimes use the cell under the checkbox with a custom number format of ;;;
This hides the value when you're looking at the worksheet--but not in the
formula bar.

And this works if the checkbox is from the Forms toolbar.
 
Top