Code VBA - knowledge and productivity add-ins
Code VBA lets professional software developers and MS Office users write VBA code faster and spend less time looking for solutions on-line:
- Context sensitive IntelliSense lets you select code from the menu. Find and insert VBA for Excel, Access and Word following the application object model. Tooltips explain what classes and procedures do and give direct access (F1) to the relevant documentation on Office MSDN online. Additionally, VBA code generators assist in writing larger blocks of code.
- Procedure Call Builders display the meaning of each procedure's argument. For each argument you can select from suitable enums, objects or variables.
- Use the Code Explorer to navigate to procedures fast and adds many useful features such as insert procedure call with arguments, test procedure from immediate window, comment code and tidy the code indentation.
- The Class Builder and UserForm builder help you create custom classes and userforms custom dialogs with validation fast and easy.
- Extend the Code VBA library with your own code fragments and resources found online.
The slides below give you an idea of what tools are included.
Help on VBA code tools.
Code VBA demo screencast.
Download free trial here.

Context sensitive IntelliSense lets you select code from the menu. Tooltips show the code that will be inserted and info on what the code fragment or procedure does and hyperlinks to Microsoft Online Help page - 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 Access VBA 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\.
Code VBA works with Works with MS Access, Excel, Word, Outlook, PowerPoint, Publisher, MS Project, Visio and AutoCad. Office 2010 - 2019 & 365, both 32 and 64 bit versions; Windows 7 and Windows 10.