OnTime for less than 1 second without becoming Unresponsive

by

OnTime can only be scheduled to run in increments of 1 second. When you attempt to schedule it at 1/10th second, you actually schedule at 0 seconds, ie it runs again immediately, consuming all resources.

Short answer, you cannot use OnTime to run an event every 1/10 second.

There are other ways, see CPearson for using a call to Windows API
Public Declare Function SetTimer Lib "user32" ...

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Function to convert column number to letter?
  3. Read/Parse text file line by line in VBA
  4. How do I find the last column with data?
  5. Excel VBA: Answer gets “stuck”
  6. How to insert a picture into Excel at a specified cell position with VBA
  7. Save multiple sheets to .pdf
  8. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  9. filter out multiple criteria using excel vba
  10. Excel VBA autofilter all but three
  11. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  12. Excel VBA code to copy a specific string to clipboard
  13. Merge values of column B based on common values on column A
  14. How to import a table from web page (with “div class”) to excel?
  15. Excel VBA – Range.Copy transpose paste
  16. How to use FindWindow to find a visible or invisible window with a partial name in VBA
  17. How do you get a Range to return its Name?
  18. Changing the date format to yyyy-mm-dd
  19. Delete all duplicate rows Excel vba
  20. Excel VBA: Convert a date string to a Unix timestamp
  21. In Excel, can I use a hyperlink to run vba macro?
  22. Vlookup to copy color of a cell
  23. every possible combination of the contents of 2 columns in excel
  24. How to delete rows in Excel based on criteria using VBA?
  25. Macro to export MS Word tables to Excel sheets
  26. VBA WinHTTP to download file from password proteced https website
  27. VBA: Modify chart data range
  28. VBA Excel simple Error Handling
  29. How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?
  30. How to save semi-colon delimited csv file using VBA?

Leave a Comment