How to give a time delay of less than one second in excel vba?

by

You can use an API call and Sleep:

Put this at the top of your module:

Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

Then you can call it in a procedure like this:

Sub test()
Dim i As Long

For i = 1 To 10
    Debug.Print Now()
    Sleep 500    'wait 0.5 seconds
Next i
End Sub

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Read/Parse text file line by line in VBA
  3. How do I find the last column with data?
  4. Excel VBA: Answer gets “stuck”
  5. How to insert a picture into Excel at a specified cell position with VBA
  6. Save multiple sheets to .pdf
  7. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  8. Excel VBA autofilter all but three
  9. How can I create a calendar input in VBA Excel?
  10. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  11. Excel VBA code to copy a specific string to clipboard
  12. Merge values of column B based on common values on column A
  13. How to import a table from web page (with “div class”) to excel?
  14. Range limit conundrum
  15. How do you run a .exe with parameters using vba’s shell()?
  16. Excel VBA – Range.Copy transpose paste
  17. How to determine the last Row used in VBA including blank spaces in between [duplicate]
  18. How can I run VBA code each time a cell gets its value changed by a formula?
  19. How to convert 32 bit VBA code into 64 bit VBA code
  20. Using VBA to detect which decimal sign the computer is using
  21. Loop through each row of a range in Excel
  22. Outputting Excel rows to a series of text files
  23. How to create a range from two ranges in VBA?
  24. XML parse VBA excel (function trip, & MSXML2.DOMDocument)
  25. every possible combination of the contents of 2 columns in excel
  26. excel vba freeze pane without select
  27. How to delete rows in Excel based on criteria using VBA?
  28. Converting a string representation of a constant into a constant?
  29. Access files with long paths (over 260)
  30. Concatenate multiple ranges using vba

Leave a Comment