Welcome to Code VBA - the Office programming power solution

Code VBA is an add-in for both professional software developers and MS Office users who need the power of Visual Basic for Applications for automation purposes and high productivity. Using Code VBA brings you many benefits:

The screenshots and texts below should give you an initial idea of what tools are included. You can give it a try for 30 days, download here.

The Procedure Builder lets you specify the basic features of a new function or sub including comments block and error handling. Quick insertion of control statements: If .. Then .. Else, Select, While, For and GoTo.
procedure builder insert of control statements
 
For user interaction many built-in and custom dialogs are made available with supporting code. Or maybe you want to make your own dialogs. Use the Userform Builder which also helps with validating the input.
built-in and custom dialogs userform builder
 
The Code Explorer is a replacement of the Project Explorer which lets you navigate to procedures and adds many new features Tooltips show the code that will be inserted and info on what the procedure does and hyperlinks to a help page if available - F1.
code explorer Press F1 for tooltip. Next F1 opens Help
 
Use the Excel VBA add-on to insert code blocks concerning Excel classes and their documentation. Use the Access VBA add-on to work with Access objects, SQL, recordsets and access their documentation.
Excel VBA MS Access VBA

Code VBA works with Office 2000-2013, both 32 and 64 bit versions: MS Access, Excel, Word, Outlook, PowerPoint, Publisher, MS Project, Visio and AutoCad in Windows XP (SP3), VISTA, Windows 7 and Windows 8.