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

"Ruth" <(E-Mail Removed)> wrote in message
news:hRi0d.379491$gE.275839@pd7tw3no...
>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
>

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.

Ruth wrote:
>
> 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

--

Dave Peterson
(E-Mail Removed)