Hi,

I'll simplify my problem to this example:

Say there is three drop down lists created from data validation in sheet1 (say in cell A10, B10 and C10 and the data in each list is used to modify cell A1 (say default is a number 1) above with various conditional if statements. So cell A1 will change based on whatever is selected from these 3 drop down lists (multiply by this, add that, etc.). That is all setup fine. Now what if I want to create a button or something else clever that by clicking on it resets all the data validation lists to their first selection, how would I do this? So list1 might currently have option 4 selected, list 2 option 7, list 3 option 9 or whatever, and hitting this reset button puts them all back to their first choice (but still allows you to continuously select the options or reset repeatedly if wanted).