VBA extensibility – using VBA to add new functionality to the VBE
It is possible to write VBA code that will function on other VBA code. This is called 'extensibility'.
top of page
Blog posts
Search
Jul 15 min read
Add a "GetEnumAsString()" Function
Get the name of an Enum member, not its value using the 'Add a "GetEnumAsString()" function' ... automatically added by VBE_Extras.
Jun 282 min read
Type Library explorer
Have you ever wanted to know what is in a Type Library without having to add a Project Reference to it from your VBA Project?
Jun 272 min read
Add Enum from Type Library
Ever needed to convert an Enum member's name to its value when changing from early to late binding? Read this ...
Jun 264 min read
Special binding
If you develop your VBA code using early binding but switch to late binding when deploying, then 'special binding' may be useful to you.
Jun 255 min read
Improving the VBE's Intellisense 'auto list members' popup
Show All Members is a larger, searchable, filterable equivalent that also shows, where available, the 'doc string' for members.
Jun 207 min read
Version Control for VBA
Turn back the clock and revert to an earlier version of your code or just view changes that have been made since an earlier point in time.
Jun 124 min read
Running code in one place when you're editing code in another ...
... is a pain with VBA when developing and running code from within the VBE ... so make life simpler with "Sub To Run" and "Run Again"
May 249 min read
Context menus and AddIns
How to use an AddIn to customize context menus in Excel - either programmatically using VBA and using RibbonX.
May 212 min read
Make a VBA Module "Option Explicit"
Have a module without "Option Explicit" and need to add it? Don't do it manually, use VBE_Extras to do it for you ...
Articles: Blog2
bottom of page