top of page
The VBA Help blog
Search
VBE_Extras is now available in Microsoft Visio and Microsoft Project
VBE_Extras is now available to all users in the VBE when hosted by Microsoft Visio and Microsoft Project.
Jun 171 min read


Callbacks in VBA using AddressOf
Most of the procedures you write are called by you, or by VBA on your behalf. A callback turns that around: you hand another piece of software the address of one of your own procedures and let it do the calling. How to do this in VBA is with the AddressOf operator.
Jun 93 min read


Beta testing of VBE_Extras in 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.
May 71 min read


VBE_Extras catch-up #10: Next / previous code reference in this 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.
May 62 min read


VBE_Extras catch-up #9: Go to declaration above / below
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.
May 52 min read


VBE_Extras catch-up #8: Backup the Project
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.
May 42 min read


Articles: Blog2
bottom of page