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

you were close

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

--


Gary


wrote in message
oups.com...
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

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?



Gary Keramidas wrote:
you were close

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

--


Gary


wrote in message
oups.com...
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

wrote:
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?



Gary Keramidas wrote:
you were close

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

--


Gary


wrote in message
oups.com...
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


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