Blog posts

Copy VBA code in colour

VBE_Extras will now let you copy code direct from the VBE 'in colour' and using a specific font name and size. How does it do this? Actually, what it does is copy the code as HTML (with some CSS for styling).

Jun 6, 20252 min read

Expand / contract the selected VBA code

Quickly expand the selection ... a word, a line, a 'block', a procedure ... and contract back to where you started

Apr 29, 20253 min read

Restore points for VBA code

Restore your VBA code to an earlier point in time with 'restore points' functionality provided by VBE_Extras.

Apr 15, 20253 min read

String interpolation

Interpolation means 'inserting one thing into another'. In this case, inserting one (or more) 'sub' Strings into another 'main' String.

Apr 7, 20253 min read

Sometimes it's just the little things - #12: The VBE_Extras Toolbar

You can now modify the VBE_Extras Toolbar so that you can directly access the commands most important to you.

Mar 28, 20252 min read

Sometimes it's just the little things - #11: Qualifying references

Automatically adding omitted Project, Module and Enum names to code references.

Mar 27, 20252 min read

Sometimes it's just the little things - #10: Better Bookmarks in VBA

I was asked if VBE_Extras has specific Bookmarks functionality. It doesn't. However, you can use Tasks to act as Bookmarks.

Mar 26, 20252 min read

Sometimes it's just the little things - #9: Auto closing pairs

As you're typing VBA code, you often need to type a pair of parenthesis, a pair of speech marks etc. VBE_Extras will help you with this ...

Mar 25, 20252 min read

Sometimes it's just the little things - #8: Move lines up or down

A quick way to move line(s) up and down within a VBE code Module

Mar 20, 20252 min read

Sometimes it's just the little things - #7: Are you still typing Debug.Print?!

Fed up with typing out Debug.Print again and again? Then don't. Let VBE_Extras do it for you.

Mar 17, 20252 min read

Articles: Blog2