Linking check boxes

  • Thread starter Alicia Rittenhouse
  • Start date
A

Alicia Rittenhouse

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) I
have the cells linked together for the text, but there are a lot of check
boxes that need to be added. I need them to be linked together so that when
one is checked it checks the one on each application. Hopefully this makes
sense. Thanks!
 
J

Jim Rech

You have to go into the properties of each check box and link them to the
same cell. So the link would include the sheet name and cell address, like
Sheet2!A1.

--
Jim Rech
Excel MVP
message |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)
I
| have the cells linked together for the text, but there are a lot of check
| boxes that need to be added. I need them to be linked together so that
when
| one is checked it checks the one on each application. Hopefully this
makes
| sense. Thanks!
|
|
 
A

Alicia Rittenhouse

I don't know why but that isn't making any sense to me. I see where you can
give both of the check boxes the same cell in the link box but how to you get
the boxes so that they are interactive, mine are all grayed. and how do put
the check box in a specific cell, mine are just hanging out there?
 
A

Alicia Rittenhouse

I don't know why but that isn't making any sense to me. I see where you can
give both of the check boxes the same cell in the link box but how to you get
the boxes so that they are interactive, mine are all grayed. and how do put
the check box in a specific cell, mine are just hanging out there?
 
Top