Forum Discussion

sure19's avatar
sure19
Copper Contributor
Mar 28, 2020
Solved

Multiple drop down list

When I select AMR it shows me the list of names for AMR, after selecting one terminal, next if I choose ANZ, till I again go to the sub selection to select the list of names from the second selector,...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Mar 28, 2020

    sure19 You can put this little macro in the code area for the worksheet (i.e. NOT in a separate module!!). It detects a change in cell D1 and blanks cell E1.

    You workbook then has to be saved as a macro-enabled one (.xlsm).

     

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 4 And Target.Row = 1 Then
    
        Range("E1") = ""
         
    End If
End Sub

    You can read more about it here: 

    https://docs.microsoft.com/en-us/office/vba/api/Excel.Worksheet.Change 

Resources