How to have vba execute every 10 minutes?

by

You should use this pattern:

Sub my_Procedure()
    MsgBox "hello world"        
    Call test ' for starting timer again
End Sub

Sub test()
    Application.OnTime Now + TimeValue("00:10:00"), "my_Procedure"
End Sub

More Related Contents:

  1. to make this code simpler
  2. Excel VBA deleting rows in a for loop misses rows
  3. What is the lifetime of a global variable in excel vba?
  4. Download attachment from Outlook and Open in Excel
  5. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  6. Embed picture in outlook mail body excel vba
  7. How to check for empty array in vba macro [duplicate]
  8. Use autofilter on more than 2 criteria
  9. What is the function of FormulaR1C1?
  10. Compiler Error: User-defined types not defined
  11. Vba Excel do vlookup from a closed file
  12. excel hyperlink to nothing
  13. How to add headers to a multicolumn listbox in an Excel userform using VBA
  14. How to send files via HTTP_POST with Excel using VBA?
  15. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  16. How to Add Date Picker To VBA UserForm
  17. Vba macro to copy row from table if value in table meets condition
  18. Difference between Thisworkbook.name and Activeworkbook.name in VBA
  19. Set a cell value from a function
  20. How to determine if a date falls on the weekend?
  21. What are the differences between using the New keyword and calling CreateObject in Excel VBA?
  22. Excel VBA wildcard search
  23. VBA Check if file (from website) exists
  24. Run-time error ’91’ (Object variable or With block variable not set)
  25. Calling regasm without administrative rights for COM interop in Excel VBA
  26. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  27. How do I activate a specific workbook and a specific sheet?
  28. Start VBA macro when editing a cell
  29. VBA Run-time error 438 appears when “paste” runs
  30. If Not function proceeds when value *is* the one specified

Leave a Comment