MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking cells


Posted by Jen on August 15, 2001 11:13 AM

I have a document w/ checkboxes. I am wanting to be able to click one check box and it to automatically click multiple corresponding check boxes below. I can get it to work for one box but not all. Please help.


Posted by neo on August 15, 2001 11:42 AM

right-click on the checkbox you'll use to control the others, select 'view code', then enter this code :

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
CheckBox2.Value = True
CheckBox3.Value = True
CheckBox4.Value = True
ElseIf CheckBox1.Value = False Then
CheckBox2.Value = False
CheckBox3.Value = False
CheckBox4.Value = False
End If
End Sub

change this code to fit your checkbox's names etc...

neo

Posted by Ron on August 16, 2001 4:54 AM

Talking about linking cells - is it possible to create a link from
one cell to another spreadsheet when you click on that cell? In other
words, I have a cell with just a little information, and if the
user wants more info on that topic, I want them to be able to click
on that cell and be lead to another spreadsheet within the same
workbook in Excel. Can this be done?

Posted by neo on August 16, 2001 9:55 AM

ok, i get it. just right-click on the cell you want to add the link to and choose 'hyperlink'. on the left side of the dilog box you can choose from linking to a place in another file or a place in the current workbook. pick which one you want then select the location and cell reference you want to go to in the boxes to the right of that.

neo