MS EXCEL: Using a little VBA to reset the value of a dependent dropdown list

Ken Atigari: Sometimes when you're building tools and forms in Excel, you'd like values in hierarchically dependent drop downs to be reset. For example, when you change the country in a drop drown from UK to Canada, you'd expect that city box is reset from London to a blank box. This video tutorial will show you how you can use VBA to do this in Excel.

[@spencermathews5936]

This was spot on what I was looking for. Add the same rule, but change the cell values for how ever many dependent lists you have and you are golden! Thank you so much for making this!

[@koushikthunuguntla6935]

how to implement same logic to entire column

[@jelorrency]

Thank you so much. Exactly what I needed!

[@georgiosvythoulkas9085]

Thank you very much. Thats exactly what i was looking for days.....

[@jeanmagara6416]

Thank you! this was exactly what I needed!

[@MsHardland]

Sir, you are my hero. thanks!

[@nidamazharali5301]

Thnak you so much for the very helpful Information.I have a question , if i want to do the same Thing again in the same sheet but this time for the different columns so how to write a code within vba worksheet.Waiting for your ResponsThanks in advance

[@omenaokoro4693]

Thank you. Worked for me.

[@mkumj]

Thanks a lot ... very helpful information

[@tullster21]

Perfect explanation.

[@liquid12327]

After the excel drop downs are created, is there any way to remove all the information so that just the drop downs show? Or you need to keep all that information (as an example, the information on the right side of your excel sheet) in order for the drop downs to still work?
Currently, we are working on an excel document, but this example wouldnt work as we cannot have all that information shown on our document twice (once written out to create the lists, then the lists themselves).

[@shindesachinkumar]

Awesome!

[@JayaLakshmi-lm8bq]

This code only the single cell reset.how to apply the code for entire column? can you help me

[@jimbradshaw6882]

the point where it is-
range ("c9").value=""
change to-
range ("c9:C40").value=""

[@1990moho]

@@jimbradshaw6882 Not Working. when I changed the first cell value , then automatically changed the other cells values.

[@plamenpetkov2592]

Thanks!!!

[@MaryHaasch]

Control + Shift + '+' to Zoom-In use '-' to Zoom-Out.

[@uzairsofiyan]

This doesn't work for me.

[@roybarkayyosef]

too long, should be more direct , yet gave me the info was looking for