Excel VBA - execute a function at a specific time

The code

Application.OnTime TimeValue("12:00:00 am"), "action"


Sub action()

' write your actions to be executed at 12 am

End Sub




Excel VBA - execute a function at a specific time like reminders open/close etc