Frncis
Member
This code below currently runs when there is a "No" response in cell Range H:H
I simplified an earlier post with the above. This is based only on a NO response.
The code below, I think should work on a numeric response.
I am I correct & how do you nest on inside the other? The user would enter NO on one entry & then Click a box that give a Boolean answer, which is converted into a numeric response.
Code:
If Intersect(Target, Sh.Range("G:G")) Is Nothing Then Exit Sub
If Target.Value <> "No" Then Exit Sub
If ReferralsCalled = False Then
The code below, I think should work on a numeric response.
Code:
If Intersect(Target, Sh.Range("Y:Y")) Is Nothing Then Exit Sub
If Target.Value <> "1" Then Exit Sub
If ReferralsCalled = False Then
Last edited: