Check box and SelectionChange

[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?

 

[mudraker]

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