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

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/reset-dropdown-file

[@tormedina9053]

No funciona el enlace!!!!!

[@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. THANKS!!!!!

[@LeilaGharani]

I'm glad to hear that. Glad it worked out.

[@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.

[@excelisfun]

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

[@krn14242]

Ditto. Very high quality video, easy code addition for great result.

[@LeilaGharani]

Thank you for your wonderful comment teammate :)

[@Alaska_Olympia]

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

[@LeilaGharani]

Happy to hear that!

[@paragmahajan2538]

Your videos are are rich source of conceptual knowledge.

[@alberthilt]

Hi Leila! Great video! How do I get the VBA reset function to work on several rows? Thanks again!

[@inesiitesk7398]

I have the same question :)

[@wayneedmondson1065]

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

[@ckokse]

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

[@LeilaGharani]

That's good to hear :)

[@TroyAngeloii]

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

[@chiragverma9230]

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 👍

[@LeilaGharani]

I'm glad the video was helpful for you.

[@vipulhavale]

Thank you very much Leila..... But configure same to all the rows. For example i have to create a table with this system. ? please help.........

[@193_rohan5]

did you find the solution?

[@IrfanKhan-wv8rh]

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

[@james_3854]

Would you be able to apply this type of logic to a form button, linked to a data validation list, that resets it to the first value (static value) each time you click the button?

[@lisauda2209]

thank you so much for this tutorial. I have a question. if I want to make this VBA work for multiple dependent drop-down lists, what code should i add?

[@ronellll]

Exactly what I want! but apparently she doesn't have that

[@193_rohan5]

@@ronellll did you find the solution?

[@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

[@neerajsahu2003]

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

[@shadkng]

Hi, great video. How can I apply the vba to multiple rows? I generally add my data to a row and then copy down hundreds if rows. Thanks

[@studioyumi]

I'm having the same problem, did you already find a solution?

[@guitari89]

I inputted the code from her example as "G6:G10" and the text applied to the subsequent rows until G10.

[@chriswilliamson7374]

Leila Thanks so much for making all the videos you do. You help so many people including me. I have a question related to DV lists and possible VB to click a button to reset a range of cells (that are DV lists) back to a specific choice. Any chance you can help me with that?

[@JulieCooper-dk3zo]

Amazing thank you! How can this apply to all lines in a table? this code only works on 1 cell. I also have several column with dependent drop down list that I would like to reset at the same time.

[@KennethJoyDaymond]

can you make this using zoho sheets? would really appreciate it

[@sterne6]

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.

[@LeilaGharani]

That's great! I'm happy to hear that :)

[@vinsmokedomi]

how to format font like color or italic for the "please select"?

[@supriyaprakash8253]

Hi Leila ,I follow all your lessons. They are very useful and informative videos. I need help in resetting dependent drop-down list for entire column. Could you please share the related video link.

[@krishnaram789]

codes is working in new Excel sheet ,but when I trying to implement same code in existing Excel sheet ,That time not working . can you please suggest.

[@timkropf4648]

venkat ram, I was having the same problem. I had more than one worksheet_change event in the worksheet that I wanted to use this in and I renamed this one to worksheet_change2. This broke the code. I renamed the first event to worksheet_change2 and this one back to worksheet_change and the code worked. From there, I took the new worksheet_change code from Leila and embedded it into the first worksheet_change code (and renamed the first one back to worksheet_change). This solved my problem. Here is the website that helped me understand that: www.mrexcel.com/board/threads/using-multiple-private-sub-worksheet_change-byval-target-as-range.1135707/

[@krishnaram789]

Hi Tim ,thanks for the reply, what I find issue in my code ,this workbook has Application.EnableEvents = false so due to this not working,but when I use Application.EnableEvents = True in my tab and need to trigger each time then it is working but that also not ever time some time working some time not. Can u plz give solution for this.

[@desapoyment-xt1dh]

All your videos are very helpful. Thank you so much. Can you also give tutorial if the dropdown list multple like 4 dropdown?

[@ianmahoney560]

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.

[@kuldipbhoir7577]

How to give range to target.address ? For example if we have dropdowns in G4:M4 column and value should clear at by individual cell in G5,H5,I5….etc only when dropdown value change in G4, H4… etc

[@moneshkankane1951]

How to select multiple values in target ?

[@thedingdong4342]

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

[@LeilaGharani]

Great to hear!

[@vapesmarter24]

is there a similar training video for this function for GOOGLE SHEETS?

[@eanava]

But what if you wanted to apply this trick to each row in a worksheet that had multiple rows? This solution only works for that first row. :(

[@richardgrant4761]

Big fan Leila! This was very helpful TY!

[@LeilaGharani]

Glad it was helpful Richard!

[@alberthilt]

... also... can this be copied to other drop downs , or do you need to create a macro for each drop down you want to use this on??

[@alberthilt]

I figured that part out!

[@193_rohan5]

@@alberthilt can you explain it please?

[@crystalnitsckie5257]

@@alberthilt Please help me figure it out too, thanks!

[@VishalPatel-lc8ty]

Thank you so much for this. How would I set the original cell to also read "Please Select..." via VBA when the workbook is open?

[@chiragverma9230]

Even i would like to know it :)

[@WizMoh777]

What if I have multiple entries using drop down and I require this effect for all of them?

[@wq2746]

Nice, thanks 🤔 wonder it will work on table row by row,

[@MalinaC]

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

[@ExcelMadeEasy444]

Great Explained. Waiting what next tutorials brings.

[@LeilaGharani]

Thank you Ashok. Looking forward to seeing you in the next ones too.

[@lmajiedmary]

Very much enjoyed!! Thank you!!

[@LeilaGharani]

Glad you enjoyed it!

[@sameersmulla]

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

[@EduardoRibeiroEdu]

You are the best Leila!

[@fatih.kocyildir]

Thanks! this was very helpful.

[@nidamazharali5301]

May I know , how to do for entire coulmn ?

[@nvalencia-kg2ws]

what if I need to write this for multiple cells?

[@OPrasannakumarBhaskar]

can we update this vba to the entire column of excell table

[@alberthilt]

Leila....thank you so much for all your tutorials. I am having trouble with this one though. It work great the first time I did it, but then I saved it(macro enabled file), now when I open the file again, it does not work. HELP!!!

[@vida1719]

Perfectly explained as always.

[@LeilaGharani]

Thanks Vida.

[@williamriley3125]

how does this apply to a range? you have one list that's being reset, but i have many. column a & b, 18 rows. validation A would reset validation B in each row :/

[@chamindabasnayake4844]

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

[@ArtByDesign80]

Great video but what is the formula for VBA if you need to apply to an entire column not just two cells?

[@archanaahvokobah5115]

How can I create a drop down list and auto populate other fields to fill in?

[@nagavamsikrishna5242]

Hi thank you for the video. I tried it is not happening ... Not showing "Please Select in the target cell. "Message box" option worked. Help me. please.

[@danielrobertson3436]

Great video. Very helpful

[@reshmajain7389]

For me it's changing value even on just moving the cursor to the Target cell, even before taking any action of changing the dropdown value. This is working fine in ur video though

[@Ps-pu3zx]

How do i change the ListFillRange in a ComboBox with a Macro by clicking on a option Button

[@pandudasari7549]

Please pleaee provide the same reset solution, without using VBA as macro is not working in free online office 365.

[@johirulislamnadeem]

How this reset can be applied to all cells of a row??

[@moneshkankane1951]

Same question

[@userdude32]

Thanks for the tutorial. Why do you need to use $ for $G$4 but not for G6? Thanks.

[@craigvoss1468]

Thank you for another great lesson.

[@LeilaGharani]

You're welcome Craig. Thanks for dropping by :)

[@obernaltablet]

Your explnatin works fine for a 2 depaendant list, how to do it for 3 dependant lists?

[@viktorija21]

Great tutolial, thanks! However, id doesn't work. What coudl be the reasons for that? I have a macro enabled excel and did all as per tutorial, but the dependent drop-down doesn't update.

[@misso5369]

I am having the same problem it's so annoying. Even the steps prior to that work with the cell reference appearing in a message pop up box. But this particular VBA code just doesn't execute even though it's exactly the same with the cell references updated. HELP! :(

[@emre318]

I had the same issue, couldn't find why. Probably it's related to some kind of version differences. How I solved this problem was recording a macro. My Excel didn't accept changing drop down list's value by referring to it such as Range("A2"). Value = blablabla. - assume A2 is the range where you drop down list located. So I enabled macro recorder and wrote the value in drop down list's cell and checked how recorder writes the code. Then I changed the value as excel did and it worked. I don't remember the code and I can't check it since I'm on mobile but you can check it on your own.

[@theaccountantguy]

Hi that's an amazing tutorial. Is there any way to do the same in google sheet?

[@FlameBeast25]

Did you find a video or figure out a solution?

[@MrProxymate]

How to reset the value in case of multilevel dependable drop down list for multiple cells in the same sheet..? Please guide by a video...

[@saebarbin4370]

i was waiting for this too

[@jennmostajo820]

Hi Leila! I've been trying to find solution from google and youtube but to no avail. Can you help me please? I have a dropdown list with codes in the worksheet to hide/unhide rows based on its cell value. Everything was working fine until I added a reset button that will reset the value of the dropdown list to "Please select". I am getting an error and it has something to do with hide/unhide codes in the worksheet. Please help. Thanks! :)

[@thanksit]

Any way to make the Please Select message in Bold or highlighted?

[@mamamtl]

What about using conditional formatting?

[@lifeofkiran6285]

thanks was scouring th internet and your videos for this solution!!!

[@LeilaGharani]

Glad I could help.

[@pratik14jan]

Man i don't need a ux guy to design wireframes, if i learn these tricks i can create forms by myself completely in excel !!

[@uzairsofiyan]

Tried using Macros, but logic doesn't get applied. Any way to troubleshoot or any other alternative than VBA.

[@jasonmanttan1756]

Hi Leila - love the videos. I learn a lot. How to I reset a dependent dropdown if the original dropdown is in another sheet?

[@anoopkumarup5078]

WHEN WE SAVE THE DOCUMENT AND CLOSE IT. AFTER OPENING AGAIN IT IS NOT WORKING

[@chrisr7694]

Awesome, thank you.

[@anupamkumar8987]

Amazing tips, thank you so much. How we can use it for multiple rows. Let's say I have a data validation drop down at E4:E200, how to used VBA code for that. could you please guide me on this? Thank you & keep rocking with your valuable content.

[@christoskonstantinou1074]

Hi Leila. GREAT tutorial! I would like to ask you how - using a macro - can I initialize the values in a number of 10 combo-boxes (i.e. to the value "Not answered" for all of them)

[@yuvaprakashthulasimani5618]

Could you please explain how to grey out and enable list validation in excel from Editing. Thanks

[@belknou6128]

can you help me i need to do this with multi columns not just on cell plz help me

[@crystalnitsckie5257]

Hi did you get the solution yet? If so, please share it with me? I am stuck...... Thanks

[@chowdhurysunzidmahbub79]

How to change Dropdown List font Size?

[@chrisfollett9866]

How do you implement this multiple different times on the same sheet?

[@chrisfollett9866]

NVM i figured it out. Its just really picky on how the code is inserted and the spacing it seems.

[@ravipremani6201]

how to give a tooltip message to all the drop down values in the drop down

[@braddenyar3641]

Strange but this doesn’t work for me in my sheet. I downloaded the version on line and it worked fine until I changed the inputs to named ranges - is there something else I need to do? Thx

[@djdisasterjames]

Hey, does this interfere with copy and paste operations? I read somewhere that Worksheet_Change and similar events can break copy and paste?

[@simoocy7948]

Hi., Thanks for the great video. But may i know how to apply to all rows?

[@YoginderKrSingh]

Hi Siti, Did you got the solution of this issue. I am looking fro same solution

[@193_rohan5]

@@YoginderKrSingh any update on this?

[@YoginderKrSingh]

@@193_rohan5 write me back on [e-mail]

[@crystalnitsckie5257]

I have the same problem. Did you find a solution yet?

[@cheewaileong2192]

Is that a formula to choose the final drop-down list instead of going through from the first drop down? When chosen the second drop-down, the first will change to the consistent data as well. Thanks in advance

[@dontbeafraid5313]

Great tutorial

[@LeilaGharani]

Glad you like it.

[@gilberttan8523]

Hi Leila, can you advise if this works with earlier version of Excel? I have created and I find it doesn't work with 2007 Excel despite Macro has been enabled. Is there anything we can do to cater for all users?

[@alleindontan]

how to do it on multiple cells

[@michaelstraus6307]

Just discovered and LOVE your videos. Question - Do you have a video for "Resetting Dependent Drop-Down" in Google Sheets? Thanks!

[@FlameBeast25]

Did you find a video or figure out a solution?

[@gourabghoshroy7484]

Mam, Great Video. But is there any VBA where we can change a drop down list based on only value (not data validation) in another cell? Helpful if you present this video.

[@ritupallavi7158]

What if we want please select to be updated in multiple cells - This macro freezes on being used for multiple data validations in the same worksheet

[@crystalnitsckie5257]

I have the same problem. Did you find a solution yet?

[@ashishranjan661]

Hi ma'am, really awesome videos made by you...which help us to learn Excel in a easy ways... please help me ... i have 10 drop-down list containing items. if i select item 1 from the first drop down. in second drop down list item option should start with item 2 ,item 3, item 4 . and so on How would this be possible... in Excel

[@karuppusamyn515]

Hi.. madam, I have a raw data in text file format. Now How to set data report viewer including print and export option like monthly time sheet with specific period in xls vba. I hope you. kindly help me.

[@Vaishnavnair25]

How to apply this for multiple rows

[@celineparenteau3587]

Could you ever solve this? I have the same issue

[@193_rohan5]

@@celineparenteau3587 did you find the solution?

[@crystalnitsckie5257]

Help me too please

[@SergoSS79]

Great Video and finally I found how to solve this. But instead of "Please select..." I would like to use first value in a new drop down list. How should I change the code in this case? Thanks!

[@tbcy97]

Thank you for this video.

[@saebarbin4370]

how to reset multiple dropdownlist... thanks I'll wait for the next tutorial my dropdown list is up to 5,000 cell. thanks

[@crystalnitsckie5257]

Hi did you find a solution yet? Please share. I have the same problem.

[@MrArmanrezaee]

Hi Leila, Thank you for your video. Can you please explain how to do the same thing when we have a ComboBox instead of Data Validation? Defining e.g. $G$4 doesn't work for when we have a ComboBox (DropDown1 for example) in our sheet.

[@LeilaGharani]

A very simple way is to manipulate the cell links of the combo boxes. Right-mouse click on the first combo box and select "assign macro" - then click on New - you'll be taken to the change procedure. In this change procedure you can force the cell link value of the second combobox to become 1. So if the cell link of the 2nd combo box is in M4, you would type in Sheet2.Range("M4").Value = 1 As the first category you could have the word "please select..." in your list.

[@soumodeepneogi9924]

@@LeilaGharani How do I get the VBA reset function to work on several rows?

[@jaymes93]

Thanks your videos helped a lot but ma'am I need help. I try taking the formula (from your previous video) and insert it into another sheet but it gives me an error. So my question is How do I take the formula (=OFFSET(F5,,,COUNTIF(F5:F14,"?*"))) and insert it into my source but in another sheet?

[@sathishkumar-hv1cv]

Hi..can you please help me how do we upload files in SharePoint using vba ..

[@Sukhvinder_Singh_Atwal]

Thank you so much mam....😊👍👍

[@nelsonku6516]

I am using Mac version of excel 2019. When I select the worksheet and try to enter the VBA command, I receive ‘Microsoft Visual Basic: Variable uses an Automation type not supported in Visual Basic’, any advice to overcome this?

[@edsonmatheus7976]

Check out this support.microsoft.com/en-us/office/-variable-uses-an-automation-type-not-supported-error-in-visual-basic-editor-in-excel-for-mac-c3125bf3-c30b-4d62-be42-d2f1bec0e5ad