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.