VBA programming knowledge and productivity add-in.
The download includes the Excel VBA and Access VBA add-ons.
After the trial period the Code VBA software stops working unless you decide to buy a license.
The software can be used with Office 2000 - 2019, both 32 bit and 64 bit versions, Windows XP (SP3), VISTA, Windows 7, Windows 8 and Windows 10.
Uses NET Framework 4.0 - if missing it is automatically installed by setup program.
Insert code from the menu. Tooltips show the code that will be inserted and info on what the procedure does and hyperlinks to a help page if available - F1.
The Code Explorer is a replacement of the Project Explorer which lets you navigate to procedures and adds many new features.
For user interaction many built-in and custom dialogs are made available with supporting code.
The Procedure Builder lets you specify the basic features of a new function or sub including comments block and error handling.
Use the Excel VBA add-on to insert code blocks concerning Excel classes and their documentation.
Use the MS Access VBA add-on to work with Access objects, SQL, recordsets and access their documentation.
Easy insertion of control statements: If .. Then .. Else, Select, While, For and GoTo. When hovering over Switch a tooltip appears showing the code that will be
inserted and a description and link to documentation for this statement.
To make your own dialogs in Excel or Word use the Userform Builder which also helps with validating the input.
You can make new code fragments available from the menu either by using the Fragment Editor ('New Fragment' on the menu), or by adding
your own code modules in the appropriate subfolder under \My Documents\VBA Code\.
Install using setup:
Run the setup.exe for the msi program to install the Code VBA software.
The setup adds a toolbar in the Visual Basic editor VBE
Note: If you get error 2503 when running the setup.exe try Run as administrator