Linking check boxes

[Secralady]

I have created an Excel form using Excel 2003. I placed a check box in cell A31 and D56. When A31 is checked I need for D56 to automatically check also. Is this possible? If so how?

Your help is appreciated.

Thanks!

 

[Sahak]

Hi Secralady,

Maybe it will help you.

As I know doesn’t matter in which cell placed check box control. Control has name & its default name comes CheckBox1, CheckBox2, CheckBox2 ……. & you can rename them if you like. In my example I gave names CheckBox_A31 & CheckBox_D56

Private Sub CheckBox_A31_Click()
    If CheckBox_A31.Value = True Then CheckBox_D56.Value = True
    If CheckBox_A31.Value = False Then CheckBox_D56.Value = False
End Sub

Copy & paste this code in worksheet’s module.

 

[Secralady]

It worked!!!!!!

THANK YOU, THANK YOU, THANK YOU!!!! I sooooo much appreciate your help as I have been working on this for 3 days now. God Bless You!!!

 

[Sahak]

You are very welcome.