RESET button for dependant dropdown list

Welcome to the forum

What are you wanting?

Have a look at the attached workbook and amend the value in G2 and then H2
- can you explain your requirements with reference to the workbook
thanks

Features
Lists are held in single column Excel Tables
Add a value at the foot of each table and it is automatically included in the table
Named ranges refer to those tables - makes them "dynamic"
Dropdowns refer to the named ranges

Change in G2 value triggers
- clearing of value in H2
- H2 becoming active cell
- dropdown list instantly available

DropdownClear.jpg

This is the only code (in the sheet module):

Please Login or Register  to view this content.

H2 - data validation is a list with source =INDIRECT($G$2)

G2 - data validation is a list with source =INDIRECT("tbl_Gender[Gender]")

Named Ranges
DependantDropdownTableNamedRanges.jpg