Data validation macro

Hello Sachin,

Not sure how you are using data validation, but try this code on your sheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address = "$H$2" Then
Range("J2").ClearContents

End If
End Sub

Note: The H2 is where your main drop list is.. the J2 is the location of the referred to drop list, change these refs accordingly.

This code goes in the code window of VB Editor, quick way to get to correct sheet code, is right click the sheet tab and select View Code, then paste the above code in the code sheet, on right of screen!

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer