Blog posts

Implement an Interface / Extract an Interface in VBA with VBE_Extras

VBE_Extras can now automatically implement and extract Interfaces for you. Both these functions are in the Refactor sub-menu.

Apr 29, 20241 min read

Implement an Interface / Extract an Interface in VBA with VBE_Extras

VBA line numbers

What's the point of adding line numbers to VBA code? Only one good reason in my opinion … error handling.

Apr 17, 20242 min read

Automatically indenting VBA code

Indenting code ... it's not sexy ... but it does make code much more readable and maintainable when done correctly

Feb 29, 20241 min read

Edit VBA using the full screen - VBE_Extra's FullScreen command

With VBE_Extras, you can go into full screen with one click. And back. As many times as you want.

Nov 27, 20231 min read

Edit VBA using the full screen - VBE_Extra's FullScreen command

VBA - highlighting references in the VBE

In any modern code development tool, you can highlight all on-screen references of a code member. With VBE_Extras, so does the VBE!

Oct 23, 20232 min read

VBA - highlighting references in the VBE

How do YOU clear the Immediate window in the VBE?

Want a better way to clear or scroll to the end of the Immediate window ... manually or automatically when you run code ... read this!

Aug 10, 20232 min read

How do YOU clear the Immediate window in the VBE?

Extract literal values (Strings, numerics, dates) to a constant in VBA

VBE_Extras includes functions for 'Matches for literal value at cursor' and 'Extract to constant' which are closely related.

Jul 25, 20232 min read

Extract literal values (Strings, numerics, dates) to a constant in VBA

Using mouse clicks to navigate VBA code in the VBE

Jump to declarations, jump to references, jump to matching literal values, highlight declarations and references ... with your mouse

Apr 20, 20231 min read

Using mouse clicks to navigate VBA code in the VBE

VBE_Extras now available in Microsoft Access

It's taken me 3 months (Access is so, so different to other Office applications!) but VBE_Extras now works from the VBE hosted by...

Mar 10, 20231 min read

VBE_Extras now available in Microsoft Access

Refactor / rename in VBA

One of the commands that is provided by VBE_Extras is the ability to rename a declaration and all the references of that declaration. It's much more than find/replace ... read this post to find out why ...

Jan 18, 20233 min read

Articles: Blog2