top of page
Blog posts
Search
A better Application.OnTime ... run your VBA code to the nearest millisecond (ish)
Application.OnTime is great if you want to call your procedure to the nearest second. What do you do if you want finer control than that?
Aug 31, 20233 min read
0 comments

Pause processing
Code often needs to pause and wait for something else to happen. There are a number of options to do this. In Excel, you can use...
Feb 22, 20222 min read
0 comments

Get the local date and time including milliseconds
This code uses the GetLocalTime Windows API to get a more accurate time than VBA will supply, accurate to around 15 milliseconds. You can...
Feb 22, 20221 min read
0 comments

Articles: Blog2
bottom of page