Linking check boxes

Secralady

New Member
Joined
Mar 20, 2009
Messages
2
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!
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Sahak

Well-known Member
Joined
Nov 10, 2006
Messages
885
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
Code:
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

New Member
Joined
Mar 20, 2009
Messages
2
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!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,127,719
Messages
5,626,469
Members
416,187
Latest member
L_D18

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top