I have a great little app. written for me by SiddharthRout which I'd like a slight enhancement for. The Macro works great however, I'd like the ability to have a cell in the spreadsheet that actually determines how many "falses" are necessary to shut down the "further questions" (currently set at 3 ((hardcoded)). I think it's an enhancement to this part of the code:
On Error Resume Next
'~~> To check for 3 false conditions
For i = j To k Step -1
If Len(Trim(Range("A" & i))) <> 0 And Range("A" & i).Offset(-1).Value = "False" And _
Range("A" & i).Offset(-2).Value = "False" And _
Range("A" & i).Offset(-3).Value = "False" Then
Target.Value = ""
Application.EnableEvents = True
I have put the change cell (IN RED) in the file example so you could see what I'm attempting to do. It's set at 3 in the code. I want to vary the number of "falses" that must be consecutively entered in order to shut down the rest of the responses within the section (for clarification, there are 12 sections w/15 responses/section but I believe they are all affected by the code above).
Thank you in advance.