The VBA Help blog

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

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

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

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...

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 ...

VBE_Extras will now help you to create and apply text, background and indicator colours, fonts and 'margin indicator bar' (MIB)...

Get fed up with manually typing out Properties? VBE_Extras can now automatically add Properties for module-level variables and Type...

What's a factory? For the purposes of this article: it is code within in a Class Module that creates an instance of that Class, assigns...

What is an Attribute? A name/value pair that specifies some characteristic of a Module or Module-member. All Attributes are hidden when editing VBA code directly in the VBE. What can I do with Attributes? All sorts of things. They define the names of Modules. They define the descriptions, seen in the Object Browser, of Modules and Module members. They define whether a class Module has a default instance, is iterable, has a default member and whether objects created from a Cla

VBE_Extras is an AddIn for the Visual Basic Editor (VBE) within Excel, Word, Outlook and PowerPoint. It is designed to make coding with...