John18 hours ago5 minAdd a "GetEnumAsString()" FunctionGet the name of an Enum member, not its value using the 'Add a "GetEnumAsString()" function' ... automatically added by VBE_Extras.
John4 days ago2 minType Library explorerHave you ever wanted to know what is in a Type Library without having to add a Project Reference to it from your VBA Project?
John5 days ago2 minAdd Enum from Type LibraryEver needed to convert an Enum member's name to its value when changing from early to late binding? Read this ...
John6 days ago4 minSpecial bindingIf you develop your VBA code using early binding but switch to late binding when deploying, then 'special binding' may be useful to you.
John7 days ago5 minImproving the VBE's Intellisense 'auto list members' popupShow All Members is a larger, searchable, filterable equivalent that also shows, where available, the 'doc string' for members.
JohnMay 175 minAdding / updating "Project References" in the VBEA better way to add, update and explore the available "Project References" (Type Libraries and other VBA Projects)