THANK YOU! THANK YOU!!! I GOT IT TO WORK! I KEPT FORGETTING ABOUT DESIGN
VIEW TOO!!! tHIS WILL HELP OUT SO MUCH! THANKS AGAIn!

"Geof Wyght" wrote:

Alicia,
You pretty well have it. But to review:
1) Add as many chechboxes as you want on any sheet.
2) Decide which is the master and which are dependent on
the master.
3) In the properties window for the master checkbox
choose a linked cell, say A1. Let's say it's in Sheet1.
4) In the properties window for each dependent checkbox,
make each one disabled and make the LinkedCell property
Sheet1!A1.
5)As you suggested, lock A1, or hide the column (say AA).
Geof.
-----Original Message-----
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?
.


.


.


.


.