L
Lisa C.
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
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