VBA Macro On Timer style to run code every set number of seconds, i.e. 120 seconds

by

When the workbook first opens, execute this code:

alertTime = Now + TimeValue("00:02:00")
Application.OnTime alertTime, "EventMacro"

Then just have a macro in the workbook called “EventMacro” that will repeat it.

Public Sub EventMacro()
    '... Execute your actions here'
    alertTime = Now + TimeValue("00:02:00")
    Application.OnTime alertTime, "EventMacro"
End Sub

Related Contents:

  1. Loop through files in a folder using VBA?
  2. Excel column number from column name
  3. Is it possible to write Excel VBA Code in Visual Studio
  4. Protecting cells in Excel but allow these to be modified by VBA script
  5. Removing the password from a VBA project
  6. How to check for empty array in vba macro [duplicate]
  7. How to continue the code on the next line in VBA
  8. Use of symbol # (hash) in VBA Macro
  9. How can I color dots in a xy scatterplot according to column value?
  10. How to wait until ActiveWorkbook.RefreshAll finishes before executing more code
  11. Determining the full type of a variable
  12. Levenshtein Distance in VBA [closed]
  13. What does the Excel range.Rows property really do?
  14. How can I generate GUIDs in Excel?
  15. Programmatic Access To Visual Basic Project Is Not Trusted
  16. vba: get unique values from array
  17. How to “flatten” or “collapse” a 2D Excel table into 1D?
  18. How do I get the old value of a changed cell in Excel VBA?
  19. Delete Sheets and avoid Excel asking the user to confirm, using custom messages instead
  20. Get User Selected Range
  21. Relative instead of Absolute paths in Excel VBA
  22. Getting Excel to refresh data on sheet from within VBA
  23. Quickest way to clear all sheet contents VBA
  24. How can I programmatically freeze the top row of an Excel worksheet in Excel 2007 VBA?
  25. Excel: macro to export worksheet as CSV file without leaving my current Excel sheet
  26. Execute a command in command prompt using excel VBA
  27. Repeated calls of Chart.SetSourceData give error 1004
  28. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  29. What is the function of FormulaR1C1?
  30. Put Excel-VBA code in module or sheet? [closed]
  31. HTML Text with tags to formatted text in an Excel cell
  32. Insert line break in wrapped cell via code
  33. Stopping Excel Macro executution when pressing Esc won’t work
  34. How do I get a range’s address including the worksheet name, but not the workbook name, in Excel VBA?
  35. Find the directory part (minus the filename) of a full path in access 97
  36. ByRef argument type mismatch in Excel VBA
  37. How to avoid using Select in Excel VBA
  38. How to comment and uncomment blocks of code in the Office VBA Editor
  39. Where does VBA Debug.Print log to?
  40. Does VBA have Dictionary Structure?
  41. Deleting a file in VBA
  42. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  43. How can I create a progress bar in Excel VBA?
  44. How can I concatenate strings in VBA?
  45. How to add default signature in Outlook
  46. Does the VBA “And” operator evaluate the second argument when the first is false?
  47. How can I create a calendar input in VBA Excel?
  48. How to get the excel file name / path in VBA
  49. How do you run a .exe with parameters using vba’s shell()?
  50. How to call python script on excel vba?

Leave a Comment