OK - I got to the point where I have two check boxes and a false/true value
in another cell. Do I link the check boxes to the cell with the true/false
value or do I to the main one? If I do it to the main one, do I have to lock
down the sheet before it will work? I can see where when I change the
true/false cell both of the boxes change to checked or not checked. So i
know I am getting there. Can you send me an email with start to finish help?
I want the main check box to be the one that you check and then it flows
through to the rest that are with in it.

"Geof" wrote:

Alicia,
You're doing the right thing. I believe they do "float"
and are not part of the contents of the cell. I suppose
you could make them look like they fit in the cell. But,
when you check or uncheck the checkbox, the linked cell
does have the value TRUE/FALSE.

Check boxes that are greyed out are disabled. The "master"
one should be enabled. If you want to have a look, I just
made up
http://geofwyght.brinkster.net/downloads/forar.xls
out on the Internet.
Geof.
-----Original Message-----
How do you actually get them in a specific cell? Mine
don't look like they
are in one, they look like they are floating on the top
of them. I am sorry
if I am not getting this, I am trying to do what you said
but I can't figure
out how to actually get the check box in a specific
cell. Plus mine are
grayed out like something is not check right?

"Geof" wrote:

Alicia
I added two checkboxes to two worksheets (using the
Control Toolbox). I assigned the same cell to each
LinkedCell property. For the 2nd checkbox the
LinkedCell
property will look something like Sheet1!A1. The
enabled
property of the 2nd one was false. Locking them doesn't
seem to have an effect, by the way. So, when I check
the
1st one, the 2nd one is checked. When I uncheck the 1st
one, the 2nd one is unchecked. Didn't think it could be
done.
Geof.
-----Original Message-----
I don't know VBA, is there another way to do this
without
having to get into
that? I tried just giving them the same name but that
didn't work?

"Geof" wrote:

Alicia,
Yes, you do need to open the properties window of
each
checkbox. There is a name property that you can
edit.
So
you could have "chk1A", "chk1B", and so on. Then in
your
VBA procedure you could test for a control name
starting
with "chk1". Just thinking off the top of my head...
Geof.
-----Original Message-----
I do not think I understand what you are talking
about.
I am the only one
working on the set up of this application/form.
But
the
people that will be
using it need to have very simple things. I guess
you
could say I do to. Do
I need to go into the properties section of the
check
box? I really
appreciate the help. Thanks!

"Geof Wyght" wrote:

Alicia,
If you have control over the design of all of the
forms,
why not give like checkboxes the same prefix for
the
control name? Then you could go through the forms
collection and look for a control with a
particular
prefix
name.
Geof.
-----Original Message-----
I am creating a form and I need to have a check
box
that
when marked checked
goes to the rest of the applications and checks
all
the
boxes for that
question in the seperate applications. I have
tried
to
link them together,
but I still can't get it to work. Am I doing
something
wrong?
.


.


.


.