Quote:
Originally Posted by macropod
Have you specified the target range?
|
this is from the code above, range:
Code:
If Target.Count = 1 Then
If Not Intersect(Target, Range("C4,C6")) Is Nothing Then
blnValue = WorksheetFunction.CountA(Range("C4,C6")) = 2
It must tick checkbox ONLY IF both cells (C4,C6) are not blank - which is thier default value !