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
- How to return a result from a VBA function
- Excel VBA – exit for loop
- Excel VBA App stops spontaneously with message “Code execution has been halted”
- How can I send an HTTP POST request to a server from Excel using VBA?
- How do I put double quotes in a string in vba?
- Display milliseconds in Excel
- How to suppress Update Links warning?
- How do I use FileSystemObject in VBA?
- How to add a custom Ribbon tab using VBA?
- What is the equivalent of “!=” in Excel VBA?
- What is the difference between dim and set in vba
- How to add a reference programmatically using VBA
- automatically execute an Excel macro on a cell change
- Refreshing all the pivot tables in my excel workbook with a macro
- “Can’t find Project or Library” for standard VBA functions
- Iterate over VBA Dictionaries?
- Get length of array?
- How to put a tooltip on a user-defined function
- Save each sheet in a workbook to separate CSV files
- Excel Macro : How can I get the timestamp in “yyyy-MM-dd hh:mm:ss” format?
- Way to run Excel macros from command line or batch file?
- Excel: How to check if a cell is empty with VBA? [duplicate]
- Refresh Excel VBA Function Results
- How to add a named sheet at the end of all Excel sheets?
- How to use workbook.saveas with automatic Overwrite
- How can I use a for each loop on an array?
- Convert string to int if string is a number
- How to get current working directory using vba?
- How to change Format of a Cell to Text using VBA
- Using a UDF in Excel to update the worksheet
- How to use the Implements in Excel VBA
- What are .NumberFormat Options In Excel VBA?
- Why cells(1,1) = 500 * 100 causes overflow but 50000*100 doesn’t?
- How to activate a specific worksheet in Excel?
- How to add a button programmatically in VBA next to some sheet cell data?
- How to Remove Line Break in String
- Skip to next iteration in loop vba
- Does the VBA “And” operator evaluate the second argument when the first is false?
- VBA check if file exists
- Excel’s fullname property with OneDrive
- How can I create a calendar input in VBA Excel?
- Border around each cell in a range
- How to get the excel file name / path in VBA
- Why MS Excel crashes and closes during Worksheet_Change Sub procedure?
- How should I make my VBA code compatible with 64-bit Windows?
- How do you run a .exe with parameters using vba’s shell()?
- Is it possible to replace Excel’s VBA Editor/IDE with a modern alternative? [closed]
- Check if value exists in column in VBA
- Closing Excel Application using VBA
- Delete a row in Excel VBA