Thread: Macro to select an item in a Validation List

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