Скачать с ютуб Reset Dependent Drop-down in Excel (with a tiny bit of VBA) в хорошем качестве

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

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou... 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. ⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/reset-dropd... 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: Dependent data validation in Excel:    • Dependent Drop-Down Lists in Excel wi...   Dependent Combo Box:    • This Excel Dependent Combo Box Solves...   VBA IF THEN Statement:    • Excel VBA IF THEN Statement (with ELS...   VBA Message Box:    • How to use the Message Box in Excel V...   Full VBA playlist on YouTube:    • Excel VBA & Macros Tutorials   ★ My Online Excel Courses (including VBA) ► https://www.xelplus.com/courses/ ➡️ Join this channel to get access to perks:    / @leilagharani   👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram:   / lgharani   LinkedIn:   / xelplus   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