CommandButton Help!

  • Thread starter Thread starter Apocracy
  • Start date Start date
A

Apocracy

i wanna set it so that when a user double click the Command Button i
sets cells J4 to J134 all to False, but i can't figure out how to d
this I am using Excel 200
 
Hi

Private Sub CommandButton1_DblClick(ByVal _
Cancel As MSForms.ReturnBoolean)
Range("J4:J134").Value = False
End Sub
 
how do i got about puting the button in and putting the code on it
cause i have tried inserying it from both the control toolbax and th
forms one. i have also tried entering the code in the Vb editor and a
a macro
 
if you but a command button from the control toolbox then double click it

This will open VB
you should have CommandButton1 in one drop down box and click other
with
Private Sub CommandButton1_Click()

End Sub

paste the code that Harald Staff posted below that

close VB Thats it
 
Back
Top