Reset Button for Drop Down Lists

DOrsini

New Member
Joined
Nov 15, 2019
Messages
1
I have a workbook with multiple drop down lists. Unfortunately, all the drop downs are not using data validation.
We need to have the list "reset" to the first item of each list. Is there a way to do this with just one Reset Button?

Thank you
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
9,879
muck up the values

turn on macro recorder

reset each from last to first

turn off macro recorded and post the code here inbetween CODE TAGS
 

Forum statistics

Threads
1,078,134
Messages
5,338,428
Members
399,232
Latest member
stevenmoritz

Some videos you may like

This Week's Hot Topics

Top