VB and check boxes in Excel

[rblivewire]

Is there any way where I can VB program a check box to check when
another check box is checked?

Ex.
If me.checkbox1.checked = true then me.checkbox2.checked = true

 

[Gary Keramidas]

you were close

If Me.CheckBox1 = True Then Me.CheckBox2 = True

 

[rblivewire]

i'm not that familiar with vb in excel as I am with it in Access. If I
click on the checkbox, how do I get to the vb code page? Also, how do
I find out the names of each check box.

I tried going to tools - macro - visual basic editor and when I try to
to input code it doesn't seem to find any of the check boxes.

Help?

 

[Ken Johnson]

i'm not that familiar with vb in excel as I am with it in Access. If I
click on the checkbox, how do I get to the vb code page? Also, how do
I find out the names of each check box.

I tried going to tools - macro - visual basic editor and when I try to
to input code it doesn't seem to find any of the check boxes.

Help?

If you're in Design mode then right click the checkbox then "View Code"

If you're not in Design mode then get into it by going
View|ToolBars|Control Toolbox|click on the Design mode button (Set
Square, pencil, ruler icon)

Ken Johnson