Quick Tip Quick Tip: Set Next Statement with Mouse Try this tip the next time you use the Edit & Continue feature when debugging. After more than 15 years of developing VBA, I'm still learning new things.
VBA Static Functions and Subs After fifteen years of writing VBA, I'm still learning new features of the language. Even if they're not particularly useful features...
Hidden Features How to Show Hidden Items in the VBA Object Browser One possible fix for the "Cannot jump to '|' because it is hidden" error is to show hidden members in the VBA object browser.
VBA Memory Management in VBA: 3 Keys to Avoiding Memory Leaks Managing memory in VBA is a piece of cake, especially if you follow three simple guidelines.
VBA Philipp Stiefel on VBA Compilation Is VBA an interpreted language? Or a compiled language? Or something in between. Philipp Stiefel shines light on the topic for us.
VBA Avoiding Overflow Errors When Defining Calculated Constants Overflow errors are usually straightforward. But what about when you get an overflow assigning a value of 1 to a Long integer?