resetting

Hey everyone, I have a button which clears all of the drop downs on my sheet ("Sheet1"). I would like to have the button also set the first drop to go to a blank option, which I already have made. Is there a way to make the drop down select it? Thanks in advance.

I'm using auto filter (Criteria1:="*abc*") to filter some data. I'd like to use another filter on that data, this time using UserInput as Criteria. How can I set up my vba code to have user input filter search the filtered data instead of resetting and searching the unfiltered data instead?

So I'm stuck trying to figure a workaround to this- I've created this fantastic, dynamic workbook with awesome help from many of you. It seems to be working incredibly well, minus a few minute bugs. Anyway, because the users aren't VBA friendly at all (really not even formula friendly), I've...