Check Boxes and Radio buttons on Worksheet

  • Thread starter Thread starter Ruth
  • Start date Start date
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
 
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...
 
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.
 
Back
Top