I am very new to this and trying to put together a form with multiple dropdowns, but want the second group of dropdowns to default to blank if the first cell is changed. I hope that made sense...
Capture.PNG
So if A26 changes I want B26 to turn blank
same for A27 and B27 and so on through A48 and B48.
And then again for C26 and D26 through C48 and D48.
I input this code and it worked perfectly for A26 and B26, but I can't figure out how to include the rest of the cells.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("A26") Then
Target.Offset(0, 1).Value = ""
End If
End Sub
Thanks!
Bookmarks