The VBA Help blog

A frustration that I have with using AI to support me in writing VBA code is generating UserForms ... specifically the UI part of UserForms. Here's a solution using an AI skill, a .frxml file and VBE_Extras.

When using VBE_Extras, you can right-click on a Project name in the VBE's Project window and choose to load an entire Project's worth of Modules at once from a set of files ... or you can save all of the Modules in a Project at once.

Looking for VBA developers who are willing to carry out some testing of VBE_Extras when the VBE is hosted in Autodesk Inventor and / or Autodesk AutoCAD.

VBE_Extras is now able to add 2,538 Windows API Functions (along with 601 Types, 99 Enums and 11,978 Consts) to your VBA code. In addition, VBE_Extras can add (or direct you to) example usages for 757 Windows API Functions.

VBE_Extras now has a Code Explorer dialog which allows you to explore the entire code base loaded into the VBE.

VBE_Extras is now available to all users in the VBE when hosted by Microsoft Visio and Microsoft Project.

Looking for VBA developers (ideally, but not necessarily, existing users of VBE_Extras) who are willing to carry out some testing ... because while I consider myself an expert in VBA and in various other Office applications, I'm certainly not an expert when it comes to Visio or Project.

A declaration can have many references and sometimes you just want to go to the location of the next, or previous, reference of that declaration. That reference might be within the same procedure / property; it might be in the same Module but may or may not be visible on-screen; or it might be in another Module of your VBA Project. The "Next code reference in this Project" and "Previous code reference in this Project" commands of VBE_Extras will do this for you.

When you have a Module with many members (i.e. Module-level declarations such as Consts, Enums, Sub, Functions etc), it can sometimes be handy to just jump through each of those declarations in turn, in the order that they are present in the Module. That is the point of the "Goto declaration above" and "Goto declaration below" commands in VBE_Extras.

Maybe you're planning on making a change to your code that you're not entirely sure you will want to keep. Maybe it's just the end of a long day of development and you want to quickly make a copy of the Workbook / Document / Presentation / Database to a "backup" folder for safety. VBE_Extras lets you do this quickly, from within the VBE.