- Insert lines or complete blocks of code: declarations, program structures (If, Select, loops), standard user interactions such as msgbox and file selection, but also new ones e,g. the SelectionBox and so on.
- Declaring variables with just a few keystrokes is a real time saver.
- Find and insert VBA, Access VBA / ADO / DAO and Excel VBA source code from the logically organized menu.
- The inserted code automatically hooks up with the already available code my matching procedure arguments with available variables.
- Extend the Code VBA library with your own code fragments.
- Tooltips show what classes and procedures do and give direct access (F1) to the relevant documentation and tutorials on Office MSDN online.
- The Code Explorer lets you move to the relevant procedures easily and adds many new 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 builderhelp you create custom classes and userforms custom dialogs with validation fast and easy.
To make your own dialogs in Excel or Word use the Userform Builder which also helps with validating the input.
The Procedure Builder lets you specify the basic features of a new function or sub including comments block and error handling.
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\.
Use the Excel VBA add-on to insert code blocks concerning Excel classes and their documentation.
For user interaction many built-in and custom dialogs are made available with supporting code.
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 documentaion for this statement.
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.
Use the MS Access VBA add-on to work with Access objects, SQL, recordsets and access their documentation.
start the demo
- Code insertion: Insert complete blocks of code declarations, program structures and procedure calls.
- The Code Fragment editor: Pick up useful pieces of code, called code fragments or snippets and store them in a logically organized library.
- Reference: Directly access the relevant documentation on Office MSDN online.
download:http://codevba.com/download.htm
药: