Code VBA - create better Visual Basic for Applications code faster
Code VBA is an essential add-in for developers of Visual Basic for Applications. A set of 20+ specialized code builders supports the creation of applications written in Office VBA. Using the builders reduces the amount of typing, makes the code more consistent and complete and reduces errors. The Line of Code Builder helps you find and use the standard VBA functions and procedures from the Office program you are working with and the macros / VBA code in your current project. An extensive code fragments library is included with hundreds of code snippets ready to be used. As such it can be used as a VBA reference as well and of course you can extend the library with your own code.
Getting started is easy: just run the setup program codevba.exe and the toolbar and menu are added to the Visual Basic editor. By pressing the toolbar buttons for Code Explorer and Shortcuts and Search two dockable windows appear. Dock the Code Explorer left and the Shortcuts and Search right of the coding pane. Now you will have to retrain yourself to stop typing and start using these time saving tools:. Below you can read what to expect.
- Finding and using (built-in and custom) procedures
- Code fragments library
- Creating your own VBA code library
- Creating procedures
- Fast declaration of variables and constants
- Working with enumerated types
- Flexible error handling
- Control structures
- Support for VBA naming conventions
Object Oriented Programming
- Builders for classes, collections and properties
- The Code Explorer shows properties and methods for each class and lets you add new.
The ability to customize the builders is very important if one wants to support different developers each with their own preferences (e.g. how to do error handling). 40 different settings logically organized let you make each builder work exactly the way you want it. Additionally the fragments (headers, error handlers, etc.) used by the builders can be tailored to your needs. With easy to memorize access keys there is no need for using the mouse.
The tools are summed up in the 'Builders and tools included in Code VBA' section. Detailed explanation of each tool is given on pages linked from there. For a quick intro consult Start using Code VBA.