Reset dependent dropdown to "Please select" on change

[juliecooper255]

Hi!
I followed the instraction in the thread below but unsuccessfully. I suspect it could be because my drop down are linear rather than column.

Reset Cell Values Based on Change to Various Cells

Good evening. I have a challenging problem I was hoping to get help with. I have reviewed other posts and found a solution that allows for clearing a range of cells based on a change, but can't find a way to clear different ranges based on different cells changing. I have dependent drop-downs...

www.mrexcel.com

Here is what I am trying to achieve:

Dropdown list in column D (all lines from D16) - When changed, reset all dropdowns in columns E,F,G,H to "Please Select"
Dropdown list in column E (all lines from E16) - When changed, reset all dropdowns in columns F,G,H to "Please Select"
Dropdown list in column F (all lines from F16)- When changed, reset all dropdowns in columns G,H to "Please Select"
Dropdown list in column G (all lines from G16)- When changed, reset all dropdowns in columns H to "Please Select"

 

[Snakehips]

Add the MsgBox line to check that the code is being triggered.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Long
MsgBox "I have been triggered"  '<<<<
    If Target.Cells.Count > 1 Then Exit Sub

 

[juliecooper255]

So I can't run it as doesn't show in the options, am I missing something? It will only appear when the suntax is Sub Worksheet_Change(). Is there another way to run this code?

 

[Snakehips]

The code, as with all Event codes, needs to be in the Worksheet Code Module to which it is applicable.
Not in a Module.
Double click the appropriate sheet name within the VBA editor project pane and paste the event code there.
It will then auto-run when its trigger event occurs.

 

[juliecooper255]

yes it worked perfectly! thank you for your help, I am learning a lot

 

[Snakehips]

Great stuff. You are welcome.