Check box and SelectionChange

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need help please

How to tie a check box with selction change event. Having selection change event run only if the box is checked?
 
One way

As you have not mentioned which type of Checkbox you have used I hav
listed 2 lots of code to cover each type pf check box




Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Range("a1") = False Then
Exit Sub
End If
your code here
End Sub


Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If CheckBox1 = False Then
Exit Sub
End If
your code here
End Su
 
Back
Top