resetting conditional drop down lists

Hello,

I have made a large number of validation drop down lists. The first entry on most of these lists is conditional and the conditions are different for each list. I always want the first entry displayed initially.

I need to develop a macro to reset all the lists when working on a new project. How do I reset it to the first item on the list without going into the long process of making if statement macros to assign values to each drop down list.

Thanks for your help!

any help would be highly appreciated

Sorry but I can't upload a sample, confidential data.

All I want to do is to be able to reset a drop down list to the first entry in the list. How can I do this?

Thank you

Validation List Sample.xls

I tried to upload a sample showing what I mean.

I want the refresh button at the button to be able to display the first entries in the two drop down lists.

Thanks agains

Please note that the N/A in the second list is conditional.

This is the tricky part. I would prefer not to use if statements in my reset macro because there are a lot of lists in this format.

Bump, Please help with this question

That worked well, thank you for the help