View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rblivewire@hotmail.com is offline
external usenet poster
 
Posts: 2
Default VB and check boxes in Excel

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