Capture.PNG
In the attached example, I have a working VBA to clear the A10:D10 Drop-Down menu when the value in A8 doesn't equal a certain value. That VBA is
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Me.Range("A8"), Target) Is Nothing Then Exit Sub
If Me.Range("A8") <> "We believe a check you deposited may not be paid for the following reason:" Then
Me.Range("A10:D10").ClearContents
End If
End Sub
Now, I basically need to perform the same function to clear A12:D12 (which is free-form text, not a drop-down) when A10 does not equal "Other:" I can't figure this out!!
Bookmarks