Sub SetAlarm() Application.OnTime 0.625, "MostrarAlarma" End Sub Sub DisplayAlarm() Application.Speech.Speak ("Hey levántate") MsgBox "Es hora de tomarse un descanso" End Sub __________________________________________________________________________________ Sub MostrarAlarma() Application.OnTime TimeValue("3:00:00 pm"), "MostrarAlarma" End Sub __________________________________________________________________________________ Sub MostrarAlarma() Application.OnTime Now + TimeValue(“00:20:00”), "MostrarAlarma" End Sub __________________________________________________________________________________ Sub DisplayAlarm() Application.OnTime DateValue("11/10/2019 10:00 am"), _ "DisplayAlarm" End Sub __________________________________________________________________________________ Dim NextTick As Date Sub UpdateClock() 'Actualiza la celda A1 con la hora actual ThisWorkbook.Sheets(1).Range("A1") = Time 'Configura el próximo evento dentro de cinco segundos NextTick = Now + TimeValue("00:00:05") Application.OnTime NextTick, "ActualizarReloj" End Sub Sub StopClock() ' Cancela el evento OnTime (detiene el reloj) On Error Resume Next Application.OnTime NextTick, “ActualizarReloj”, , False End Sub __________________________________________________________________________________ Call StopClock __________________________________________________________________________________ Sub Setup_OnKey() Application.OnKey "{PgDn}", "PgDn_Sub" Application.OnKey "{PgUp}", "PgUp_Sub" End Sub Sub PgDn_Sub() On Error Resume Next ActiveCell.Offset(1, 0).Activate End Sub Sub PgUp_Sub() On Error Resume Next ActiveCell.Offset(-1, 0).Activate End Sub __________________________________________________________________________________ Sub Cancel_OnKey() Application.OnKey "{PgDn}" Application.OnKey "{PgUp}" End Sub __________________________________________________________________________________ Application.OnKey "%{F4}", "" __________________________________________________________________________________