Code VBA 4.0

Code-VBA 4.0 is exactly what you are looking for. With Code-VBA coding tools added to the Visual Basic for Applications editor programmers create better Visual Basic code faster. A set of 25 specialized code builders supports the fast creation of most used code. Using the builders reduces the amount of typing and makes the code more consistent. Use it with MS Access, Excel, Word and other VBA supporting applications. Included Code Explorer and Search to find all built-in Visual Basic procedures and code fragments related to your keywords easily. Version 4 has the Fragments Builder extended with the ability to add shortcuts. This allows you to access the same fragment from multiple branches in the fragment library tree. Recently an Object names insertion tool was added.

VBA coding tools help create better VBA code faster. A set of 25 specialized code builders supports the fast creation of most used code. The integrated  code fragments library lets you find programming solutions easily.

Support for Microsoft Access and Excel

• Line of Code Builder shows all Microsoft Access and Excel built-in functions
• Fragment Builder has many fragments showing how to do things typical for Access such as database actions (DAO / ADO) and Excel such as moving thru ranges, selecting cells, setting properties, opening dialogs, etcetera.
• Insert Variable automatically picks up controls when in a Form module.
• New Create class from table (in Class Builder)

Major Features:

1. Code Library
   
   • Finding and using (built-in and custom) procedures
   • Code fragments library
   • Find all built-in VBA procedures and code fragments related to your keywords easily.
2. Code Generators
   
   • Creating procedures
   • Fast declaration of variables and constants
   • Working with enumerated types
   • Flexible error handling
3. Object Oriented Programming
   
   • Working with classes, collections and properties
4. VBA Programming
   
   • Additional support for Microsoft® Access® and Microsoft® Excel®
   • A collection of 200+ typical VBA code fragments (Excel, Access, DAO, ADO, ...) for use with Fragments Builder
     

Enhancements:

• Fragments extended,
• Object names insertion added
  

Requirements: MS Office 2000 or higher