delete value if adjacent cell changed

[ajm]

I am using dependent validation to give some flexibility in a model. first drop down gives the users several options. The second list, dependent on the first choice, is either a hyphen, or one of several other options. So, if the user picks option A in the first drop down, the adjacent cell becomes " - ". Selecting options B-F, will result in the a range of other values from which they can select. That part is fine. However, if the user, for whatever reason, comes back later and changes the selection in the first list, they may not think to also reselect the second option. so, is the only way to do a sheet change event in VBA?

 

[ajm]

i have used the following and solved my own question. easy peasy.

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Application.Intersect(Range("c4:c500"), Range(Target.Address)) Is Nothing Then
   If Target <> CellValue Then
       Target.Offset(0, 1).ClearContents
      Target.Offset(0, 2).ClearContents
   End If
End If

End Sub