When to use Code VBA tools

This page gives an overview of the moments you will be using Code VBA tools.

Note: obviously another good way to see what is available is to check out the Code VB menu which is added to the Visual Development Environment.

• Create new procedure: Procedure Builder
• Add class (and collection class and properties): Class Builder, Property Builder
• Add variable: Speed Declare, Variable Builder
• Add constant: Speed Declare, Constant Builder, Insert Objectname, Object Inventory
• Insert variable, use With
• Enumerated constant: Enum Builder, Add Const To Enum
• Writing and reusing codes: Fragment Builder, Line of Code Builder
• Adding control structures  (if then, loop, goto, exit) 
• Select case: Select Case from Enum Builder
• Error handling: select in Procedure Builder, add afterwards via menu, line numbers,  debug statements
• Insert Objectname
• SQL in code: Insert Objectname
• Find procedure or fragment to use: Shortcuts and Search, Code Explorer, Fragment Builder, Line of Code Builder
• Create your own reusable library: Fragment Builder, Code library
• Comment lines