Linking check boxes

[Guest]

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?

 

[Guest]

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

 

[Guest]

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!

 

[Geof Wyght]

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.

 

[Guest]

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]

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.

 

[Guest]

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]

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.

 

[Guest]

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]

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.

 

[Guest]

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 Wyght]

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.

 

[Guest]

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

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!


.