Reset Dependent Drop-down in Excel (with a tiny bit of VBA)

Learn how to reset a dependent drop-down list in Excel with a little bit of VBA. The problem we get with dependent data validation lists is that when you change the value of the first data validation, the value for the dependent data validation stays there until you activate the drop-down. This can be misleading. In this video, you will learn how to automatically reset the value of the dependent list to say "please select" the moment the value in the first drop-down list changes.

We do this with Excel VBA, using the change event procedure. The default worksheet procedure is Selection Change event. This triggers every time you change the active cell. It's more optimal in this case to use the worksheet change procedure and make sure that it only run if the value of a specific cell is changed. We don't want to trigger the change procedure every time any cell value is changed.

The simple Excel macro show you how you can set it up from scratch. Once you're done, make sure you save the workbook as a macro-enabled workbook.

LINKS to related videos:

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel #ExcelVBA

[Alaska_Olympia]

I'm flying through my assignments at work which will be making me look good, thanks to these tutorials. Thank you Leila!

[wayneedmondson]

Hi Leila.. excellent method to keep the user from being confused when the master drop-down changes. Thanks and Thumbs up!

[khinkey]

I spend hours looking threw different peoples solutions from a google search and NOTHING was just this simple. This worked perfectly, and with the smallest amount of code I have seen yet.

[paragmahajan]

Your videos are are rich source of conceptual knowledge.

[ianmahoney]

Thanks for the high quality videos, they have helped me tremendously.

It would be fantastic if you could do some videos on creating a personal finance/budget spreadsheet. I'm sure a lot of people would highly regard it and learn a lot.

Thanks.

[excelisfun]

Thanks for the amazing high quality video, as always ; )

[doorbs]

Thank you so much for your wonderfully detailed yet easy to follow videos!! They have saved me so much time over the last few months. Have a wonderful Christmas and I look forward to more in 2019

[alcoolbc]

I know this video was published quite a while ago, but it came in handy today helping me clean up dynamic drop down list issues (annoying CALC! error) and setting up filters via those multiple selections. Thanks, again.

[chamindabasnayake]

Thank You! This tutorial gave a solution to a problem which I had since my first dependent dropdown list.

[chiragverma]

Awesome tutorial, saved my day. I have multiple dependent drop down. If one changes other subdependent cells should also change. So i have copied the code and pasted changing the target address and range adress. Kudos to you and your team 👍

[IrfanKhan-wvrh]

Wow!! A very useful tips for us. Thank you so much ma'am. You are really good teacher.

[sterne]

That‘s amazing. Thank you so much. Your video gives a solution to the problem which I have faced already many times with dependent drop-down lists, when the values were not changing automatically.

[TroyAngeloii]

I'm your big fan. This vlog is a very big help on the report that I am doing. 👍👍👍

[ckokse]

Never thought I would ever try out VBA but with your guidance it actually is much less threatening.

[thedingdong]

Thank you very much for the great tutorial. This is exactly what I've been looking for!

[MalinaC]

Thank you for an awesome video and VBA fun! It is super cool, that validation doesn't validate VBA ;)

[neerajsahu]

Really Thankful to you. You solved my big problem of excel.Again Thank You

[sameersmulla]

Thanks for the Amazing video, It is helping us in depth....

[ExcelMadeEasy]

Great Explained. Waiting what next tutorials brings.

[richardgrant]

Big fan Leila! This was very helpful TY!