Linking check boxes
 

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?

Linking check boxes
 

hi,
more information might be helpful.
what are these "other application" you mentioned?

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

Linking check boxes
 

I work for an insurance agency. We have many different companies that
require their own applications. Each companies own application must be
filled out. So I created a master application that you fill out (it's in a
worksheet) and it populates the different questions on the seperate
applications (also on seperate worksheets but all in the same work book) Let
me know if you still need more info. Thanks!

" wrote:

hi,
more information might be helpful.
what are these "other application" you mentioned?

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

Linking check boxes
 

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

Linking check boxes
 

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

Linking check boxes
 

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


.

Linking check boxes
 

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


.

Linking check boxes
 

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


.


.

Linking check boxes
 

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


.


.

Linking check boxes
 

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


.


.


.

Linking check boxes
 

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


.


.


.

Linking check boxes
 

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


.


.


.


.

Linking check boxes
 

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


.


.


.


.

Linking check boxes
 

Good!
-----Original Message-----
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?
.


.


.


.


.


.