Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
CASCADING LIST BOX | Excel Discussion (Misc queries) | |||
clean duplicates in list | Excel Discussion (Misc queries) | |||
Create a cascading list box using Excel | Excel Discussion (Misc queries) |