VBA code to clear contents

[Delta729]

Okay, I'm a complete vba novice, so I hope that I'm wording this correct.

I have a spreadsheet that has two drop downs in an Excel table. In the 4th column (D) and a dependent drop down in the 5th column (E). This is set up and works great, but I would like to add some vba code so that if they change the selection in the 4th column it will also remove the selection (or clear the selection) that was in the 5th column. It's set up in a change event, but I'm not sure how to code it? It's probably pretty easy, but everything I keep finding as an example reference one specific cell, and any contents in the column.

Any help would be great.

[cytop]

Check the column of the changed cell and, if 4, clear the cell to the right (I assume you didn't mean to clear the entire column). This will not affect any Data Validation in the cell in Col 5...

Please Login or Register  to view this content.

[Delta729]

Perfect, thank you so much.