Throwback Thursday: January 9, 2025
With over a million words scattered across more than 1,300 articles on this blog, you've probably missed a few things here.
That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.
Highlights from NoLongerSet.com
Demystifying DoEvents
The DoEvents function may be the single most misunderstood piece of code in the entire VBA language. In this series of articles, I’ll try to remedy that.
How to Teach a Six-Year Old About the DoEvents Function
I challenge you to read this article without laughing or learning anything new about the DoEvents function.
How to Use the DoEvents Function: A Demonstration
The demonstration and downloadable sample code in this article make it easy to understand how DoEvents works.
When (or Should I Say, How Often) to Call DoEvents
Too few calls to DoEvents, and your app may appear to be ”(Not Responding).” Too many calls to DoEvents, and your app will run slow. Let’s Goldilocks this thing.
A High-Level Overview of the DoEvents Function Call
Why does calling DoEvents save us from the dreaded ”(Not Responding)” treatment? It’s all about handling “Windows Messages.”
How DoEvents Works: The Nitty-Gritty Technical Details
A peek behind the scenes at the inner workings of the DoEvents function.
Wisdom from Around the Web
DoEvents in Microsoft Access VBA - Computer Learning Zone
Use the DoEvents Command to Yield Execution to Other Processes During Loops in Microsoft Access
Avoid Using DoEvents to Wait in Microsoft Access, VBA, and VB6
Code for waiting a specified amount of time, or waiting until a specific time to continue code, without using DoEvents
Developer Humor
Theory vs. Practice
This pretty much sums up my entire experience with DoEvents:
Cover image generated by Ideogram