VBA code to reset dependent dropdown

[Donutderek]

Hello,

I've got a workbook I've been working on with primary drop-downs located in col G, cells 13, 14, 15,(merged cell with H&I), my dependent drop-down is in C of the same rows. (Merged cell with D). Despite trying codes copied from forums here and adjusting the locations to my situation, I can't seem to get it to work when I test it. I'm trying to get the dependent drop to reset when my primary value has been changed. Nothing I've tried seems to work.

 

[Donutderek]

Sorry, obviously I'm new to coding this, any help would be appreciated in how to handle this. Thank you!

 

[Danmc]

can you post your code (whatever you have)?

 

[Donutderek]

can you post your code (whatever you have)?

I've tried copy and pasting multiple ones from this forum, but the latest one I have is this:

Private Sub Worksheet_Change (ByVal Target As Range)
If Target.Address = "$G$13:$G$15" Then
Target.Offset (0,-4).Value = " "
End If
End Sub


I don't know the best way to go about this, but it doesn't seem to matter what examples I've tried, it never tests correctly.

 

[Danmc]

so if i understand your code (should work), you would clear the contents of G17 to G19 if the cells in G13 - G15 change, is that correct?

 

[Donutderek]

If that's the code I've put in, then no wonder it doesn't work. Lol. I would like to clear contents of cell C13 if G13 changes, clear C14 if G14 changes, etc.

 

[Fluff]

You're code is looking to clear col C.
How about

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("G13:G15")) Is Nothing Then
   Target.Offset(0, -4).Value = ""
End If
End Sub

 

[Donutderek]

Omg. Fluff. That did it. Thank you so much!
One last question:
Is it possible to populate cell D13 (same row) based on selection of dependent dropdown? (The value I want to put in there is in the cell directly next to where the source of dropdown selection is). I can't find anything about this, (VBA or formula) but I'm likely not wording it properly.

Example: Dependent dropdown is in C13: selection source is located in Sheet 2, cell A4.
Can I populate D13 automatically with the info from Sheet 2, cell B4?

 

[Fluff]

You can do that with either a Vlookup, or Index/Match
https://exceljet.net/excel-functions/excel-vlookup-function
https://exceljet.net/index-and-match

 

[Donutderek]

Perfect. Thanks again. Saved my sanity.