No Longer Set
  • Home
  • Topics
  • Code Library
  • Tags
  • About
Subscribe
Tagged

VBA

A collection of 6 posts

Quick Tip: Set Next Statement with Mouse
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.

  • Mike Wolfe
Mike Wolfe May 5, 2022 • 1 min read
Static Functions and Subs
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...

  • Mike Wolfe
Mike Wolfe Apr 20, 2022 • 2 min read
How to Show Hidden Items in the VBA Object Browser
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.

  • Mike Wolfe
Mike Wolfe Apr 11, 2022 • 2 min read
Memory Management in VBA: 3 Keys to Avoiding Memory Leaks
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.

  • Mike Wolfe
Mike Wolfe Mar 29, 2022 • 7 min read
Philipp Stiefel on VBA Compilation
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.

  • Mike Wolfe
Mike Wolfe Mar 24, 2022 • 1 min read
Avoiding Overflow Errors When Defining Calculated Constants
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?

  • Mike Wolfe
Mike Wolfe Mar 10, 2022 • 3 min read
No Longer Set © 2022
Powered by Ghost