Clear downstream dependent data validation lists

[ChrisTag1]

Hi all,
I am fairly new to excel, and I am basically trying to teach myself the ins and outs with the help of google, books and help forums. I am mostly successful at working out my own problems, but I've finally come across one that I am hoping someone here can help me with, without going too "techy" on me.

I have a worksheet that is 12 columns wide and 526 rows long.
Columns 5-8 (E,F,G,H) are a table. (tblData) - this table has a dependent dropdown list.
E4 is my "parent" dropdown - the next 3 columns are dependent on the column previous.

I have made a fairly simple VBA to clear downstream contents in the data validation lists.

My problem is, the VBA only works for the first row, and not the other 525 rows in my table. I am not sure how to edit the code to include the entire table.


Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("e4").Address Then
Range("f4").Value = ""
End If

If Target.Address = Range("f4").Address Then
Range("g4").Value = ""
End If

If Target.Address = Range("g4").Address Then
Range("h4").Value = ""
End If



End Sub
If anyone can help me with this, I would very much appreciate it.
Thanks much

Also, if someone wants to tell me how to attach a file so I can show my excel sheet, that would be great. The attachments icon doesn't seem to do anything.

[CK76]

Try...

Please Login or Register  to view this content.

[ChrisTag1]

CK76
That works fantastic. Thank you so much.

I have so much more to learn, it's an ongoing process.

Cheers.

[CK76]

You are welcome