View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lisa C. Lisa C. is offline
external usenet poster
 
Posts: 23
Default Clean-Up Cascading Data Validation List Values

I have two dependent data validation lists. The first list (in cell A1)
determines the values on the second list (in cell A2). When the value
selected in cell A1 is changed, the following code blanks out any value
already selected in cell A2. The code works when the value in cell A1 is
changed to a new value, but it doesn't work when the value in cell A1 is
deleted or blanked out. How can I fix this?

Option Explicit
Private Sub worksheet_change(ByVal target As Range)

If target.Address = "A1" Then
ActiveSheet.Range("A2").Value = ""
End If

End Sub