Forum Discussion
How to clear a cell based on a change in a different cell
Hi All I have created a dependent drop down list where e.g. A3 is Fruit, B3's drop down list = apple, banana, kiwi etc. And if the user changes A3 to Veggies, B3's drop down list = carrot, peas, e...
Like this. Adjust the range as needed.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("A3:A1000"), Target) Is Nothing Then
Application.ScreenUpdating = False
Application.EnableEvents = False
Intersect(Range("A3:A1000"), Target).Offset(0, 1).ClearContents
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End Sub- Thank you so much!!! This worked perfectly 🙂
