top of page
The VBA Help blog
Search
VBE_Extras catch-up #5: References for code at cursor
If the cursor is on a declaration, or on a reference of a declaration, then the "References for code at cursor" command will display a dialog with a list of all references of that declaration (including the declaration itself). So it could be every place that a variable is referenced. Or every place that a procedure is referenced. Or a constant. Or an Enum, a Type ... or any other type of declaration.
Apr 293 min read
Â
Â


VBE_Extras catch-up #4: Info for code at cursor
Getting information about the code at the cursor ... for declarations in your VBA Project, and things declared outside of your VBA Project
Apr 282 min read
Â
Â


VBE_Extras catch-up #3: Project statistics
Ever wanted to know how many procedure or properties there are in your Project? Or how many code / comment / blank lines? Or how many of those lines are declaration lines? The the Project Stats command is for you.
Apr 242 min read
Â
Â


VBE_Extras catch-up #2: Listing all declarations
VBE_Extras will show a dialog containing a list of all declarations from any procedure/property, Module or VBA Project.
Apr 233 min read
Â
Â


VBE_Extras catch-up #1: The Module-picker (and the Project Picker)
The Module-picker is a quick, keyboard-centric way of navigating between Modules in a VBA Project, so it's of most benefit to people that prefer using the keyboard to navigate around a Project rather than the mouse. It replaces the build-in behaviour of the VBE that acts in a similar, though less user-friendly, manner.
Apr 223 min read
Â
Â


Opening Microsoft documentation web pages using VBE_Extras
A feature that I felt was missing from VBE_Extras was the ability to open the Microsoft documentation web pages. This feature now exists.
Feb 183 min read
Â
Â


Fixing the letter case of code in the VBE
The VBE has a habit of changing the letter case of words (that are code ... not literal values and/or comments) when you are typing in code. For example, I often find that the letter casing of the word "Value" gets changed to "value". VBE_Extras now includes a "Fix case" command that will correct the case for all matches of that word.
Jan 261 min read
Â
Â


AutoText - numeric and String expansions
The AutoText functionality of VBE_Extras already provided numerous ways to speed up entering code ... now it has one more trick up its sleeve: numeric and String expansions for ++, --, +=, -=, *=, /=, \=, ^=, &=
Jan 222 min read
Â
Â


Consts to Enum / Enum to Consts
VBE_Extras will now convert declaration(s) between Consts and an Enum. If the cursor / selection is one or multiple Consts, VBE_Extras converts those Consts to an Enum (one Enum member for each Const). If the cursor is within an Enum (or the entire selection is an Enum), VBE_Extras converts that Enum to Consts (one Const for each Enum member).
Oct 15, 20251 min read
Â
Â


Using 'F1' to view Windows API web pages
VBE_Extras extends the built-in "F1" functionality to open the Microsoft documentation web page for Windows API Functions (i.e. that you have declared using the 'Declare' keyword), Types, Enums and Consts.
Aug 19, 20252 min read
Â
Â


Articles: Blog2
bottom of page