Hi, I've been getting a lot of great help in here but I needed one more answer to complete my current Excel project.
I would like to create a "Reset" macro that will change a couple of validation lists back to the first choice; which is "All".
This one works but it does not trigger my other code when "All" is typed in there:
Sub ResetAll()
Application.ScreenUpdating = False
Dim myRng As Range
Set myRng = Range("D3:D5")
myRng.Value = "All"
Set myRng = Range("D3")
myRng.Value = ""
Application.ScreenUpdating = True
End Sub
Is there a way to make the macro select the item because this one seems to type it in but it doesn't cause my other code to trigger upon clicking the macro.
Thank you for any help!
-Evan
Bookmarks