|Buy Today (below) and send us your order ID and claim over $70.00 worth of FREE software|
With Code VBA coding tools added to your Visual Basic editor (VBE) you create better VBA macros faster. A set of 17 specialized code builders supports the fast creation of most used code. Use with MS Access, Excel, Word and other VBA applications
With Code-VB/VBA coding tools added to your Visual Basic development environment you create better Visual Basic code faster. A set of 17 specialized code builders supports the fast creation of most used code. The integrated code fragments library lets you find programming solutions easily.
Code Line builder: insert VB and custom procedures. Tab to move thru the procedure' s arguments while selecting or adding variables.
Fragment builder: lets you use & store fragments of code which you apply many times. Typical fragments would consist of open/read/close on datasets or files, insertion of code change marks, test if file exists, etcetera.
Fragment editor: create new fragments. Insert markers indicating what positions and roles are available and how they are to integrate with the other builders.
Procedure builder: Add procedure with arguments including selected type of error handling, header info (author, date, description...), etcetera into selected module.
Class builder: allows you to create both a class and a corresponding collection class in one go. For example a Task class together with a Tasks collection. The collection includes methods for adding items, class initialization and termination and an ItemExists function.
Property builder: Adding properties to classes is rather time consuming. This builder does the obvious things. It is a part of the class builder, but can also be Start ed directly from a class module to add a couple of properties.
Variable builder: declare variables without moving from the current position. The variable is added at the top of the procedure, in the procedure's interface or in a selected module. A copy can be pasted at the current position, the place where you actually use it.
Insert Variable: lists all variables in scope. Special support is built-in for the Office apps Access and Excel. Access: if coding in form module variables representing the controls are included. Excel: Named ranges and typical object references such as ThisWorkbook and ActiveCell.
Argument builder: is Start ed from the procedure builder to speed up defining the procedure's arguments.
Constant Builder: define constants without moving from the current position. The constant is added in the module you selected, a copy at the current position. A good practice is to have a module where you keep your constants. Using constant builder you don't have to switch modules.
Explicit argument: When you are working on existing code (refactoring?) and you want to make things more clear, this lets you make the argument explicit without having to type the full argument name. (If you insert a new procedure call and want explicit arguments the best way is to use Line of Code Builder.)
Enum builder: using enumerated constants is considered a professional coding practice. It is a practical way to sum up the different cases that need to be considered, typically in a Select Case or For Loop constructions. The builder encourages using this technique. Use 'Add Constant to Enum' item in the Code-VB menu to add new constants.
Fast Declare: In most cases when declaring variables, properties or constants you only care about the name and type. E.g. if you select Alt CVS (Code-VB ► Variable ► String) an Input box pops up in which you type the variable name. The result is the same as when you would have selected the variable builder, with all default options.
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates