Reset Dependent Drop-down in Excel (with a tiny bit of VBA)
December 13, 2018 Excel Hacks: Tips & Tricks
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.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/reset-dependent-drop-down/
LINKS to related videos:
Dependent data validation in Excel: https://youtu.be/w7cHgsFirLk
Dependent Combo Box: https://youtu.be/aSPtWo3IiOM
VBA IF THEN Statement: https://youtu.be/dUSQ7wZHM7A
VBA Message Box: https://youtu.be/EwbTFvXBfns
Full VBA playlist on YouTube: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se
★ My Online Excel Courses (including VBA) ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
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!
#MsExcel #ExcelVBA
-
31:38
Another Boring Topic
6 months agoThe Rise of Microsoft Excel Part 1
25 -
58:02
Excel For Freelancers
3 years agoHow To Find & Fix Multiple VBA Bugs In Excel [Data Entry Form Update]
23 -
5:07
Tuts4dummies
9 months agoExcel | VBA | How To Delete A Chart | Part 4
4 -
32:01
Microsoft Excel Full Course
3 years agoExcel 365 Visual Basic Part 29 – VB Editor
78 -
0:20
Mighty Excel
2 years agoBasic Excel Tips Trick (Drag and Drop) Part 5 #Excel #Learn
4 -
40:58
Excel For Freelancers
3 years agoHow To Automatically Drill Down Data In Excel on a SINGLE Click
58 -
1:18
TechSolutions
1 year agoHow To change Cell Selector value in excel
50 -
42:42
Microsoft Excel Full Course
3 years agoExcel 365 Visual Basic Part 39– Worksheets
134 -
5:47
Tuts4dummies
9 months agoExcel | VBA | XML | Create XML File | Part 1
7 -
8:52
Tuts4dummies
9 months agoExcel | VBA | Read From XML File | Part 3
7