list box initialization

[Avinashch]

Hi All,

I have two data validation lists in sheets. One for region and second for countries in that region. I want the country list to be blank when region changed. List country is a subset of List region.

Any help shall be highly appreciated.

[nigelbloomy]

Add this into the code for Sheet1 (India). It just listens for a change to the region dropdown and then clears out the country dropdown.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$4" Then
    Range("B7").ClearContents
    Debug.Print "I ran"
End If
End Sub