Settings

The ability to customize the builders is very important if one wants to support different developers each with their own preferences . 40 different settings logically organized let you make each builder work exactly the way you want it.

Controls:

OK

Save changes to settings and close dialog.

Cancel

Close dialog without saving changes to settings.

Apply

Save changes to settings without closing dialog.

Help

Start this Help topic.

Library Folder

Initials

Initials of the developer. Can be used in fragments such as Comments by inserting {INITIALS}

Organization

Name of the organization for or by whome the software is being developed. Can be used in fragments such as module header by inserting {COMPANYNAME}.

Copyright

Default Error Handle

The error handler fragment inserted when the user selects

menu: Error > Add Error Handling

You can make your own error handler using Fragment Builder > New (starts Fragment Editor ) and Save it to the fragments subfolder 'ErrorHandlers'

Error Handle Procedure

Error Handle Module

Name of the module and procedure for centralized error handling.

Error Handler

Default label to jump to for error handling.

Exit Handler

Default label to jump to when the procedure needs to be abandoned.

Make Procedure Constant True

Check this if the centralized error handling wants to pick up the name of the procedure for use in the error message or error log.

Make Module Constant True

Check this if the centralized error handling wants to pick up the name of the module for use in the error message or error log.

Auto Prefix Variable Name

Options:

Always Auto Prefix
No Auto Prefix: No prefix activity is done.
Auto Prefix before capital char: Only if the picked up word begins with a capital. E.g. if selected text is 'Name' then in Variable Builder do 'strName'. If 'name' then pick up 'name' (without adding prefix)

Type Prefixes

Add, change or remove prefixes to be used in this textbox. Each prefix on a separate line. Multiple prefixes separated by comma (',') indicate that whichever string is found it will interpret it as the type specified on the left.

Set Picked Up Name Uppercase

In the above example 'Resource Management' changes to RESOURCEMANAGEMENT

Const Tag Before Type Tag

Specify which character is to be used as prefix, if any.

ConstTag

Specify which character is to be used as prefix, if any.

Module Name Constant

Decide how you want to name the module constant if module constant is inserted (see Procedure Builder )

Private Const cstrModule As String = "ThisWorkbook"

Procedure Name Constant

Decide how you want to name the Procedure constant if module constant is inserted (see Procedure Builder )

Const cstrProcedure = "MyProcedure"

Declaration Indented

If true variables and constants will be inserted one tab from the left,

Sub MySub()
Dim Var1

else they will be fully at the left.

Sub MySub()
Dim Var1

View Shortcuts and Search Window

View Code Explorer Window

View Tip of the Day on Startup

Add Error Handling Procedure

Set default error handling , if any, from the combo box

Add Header Procedure

Whether to include procedure header text or not. The template for s

Add Procedure Constant

If checked the following line is added:

Private Const cstrProcedure As String = "[Procedurename]"

Add Module Constant Procedure

Generally used for error reporting to indicate where the error occurred.

Private Const cstrModule As String = "ThisWorkbook"

Add Hourglass Procedure

If the process involved with the property is lengthy, it makes sense to add Hourglass.

Arguments on Separate Lines

Determines if all arguments are placed on the same line ...

Sub MySub (Arg1, Arg2, ...)
... or each on a new line: Sub MySub (Arg1, _; Arg2, _; ...)

Add Return Statement

In case it is a function there will at least be one statement determining the value to be returned. Check this to get such a statement inserted as default:

Function MyFunction() As String

MyFunction =

End Function

AddErrorHandlingProperty

Set default error handling , if any, from the combo box.

Add Property Constant

Generally used for error reporting to indicate where the error occurred.

Private Const cstrModule As String = "ThisWorkbook"

Add Module Constant

Decide how you want to name the module constant if module constant is inserted (see Procedure Builder )

Private Const cstrModule As String = "ThisWorkbook"

AddErrorHandlingMethod

Add Header

Whether to include procedure header text or not.
You have to determine in each case if you want this additional text.

Add Method Constant

Generally used for error reporting to indicate where the error occurred.

Private Const cstrModule As String = "ThisWorkbook"

Add Module Constant

Generally used for error reporting to indicate where the error occurred.

Private Const cstrModule As String = "ThisWorkbook"

Add Hourglass

If the process involved with the property is lengthy, it makes sense to add Hourglass.

Include Comment

Explicit Arguments

Each Argument on a New Line

Determines if all arguments in a procedure are placed on the same line ...

MySub Arg1, Arg2, ...
... or each on a new line: MySub Arg1, _; Arg2, _; ...

Open On Current Project

Insert Return Values

Applicable when generating the Select Case from Enum inside a function which returns a string. Example is to generate a string representing the selected (Gradient-)type

Function Gradient2String() As String
Select Case GetGradient
Case msoGradientDiagonalDown
    Gradient2String = "GradientDiagonalDown"
Case msoGradientDiagonalUp
    Gradient2String = "GradientDiagonalUp"
Case msoGradientFromCenter
    Gradient2String = "GradientFromCenter"

...
Case msoGradientVertical
Gradient2String = "GradientVertical"
End Select
End Function

Prefixes work two ways:
1. derive type and level/interface from prefix
1.a if the selected text has a prefix then on start of a builder the type is determined/set automatically (Constant Builder, Variable Builder, Fast Declare). In Var/Const Builder prefix can also be used to distinguish level/interface
1.b if the user types in a Name in a builder if it contains a prefix the type can be determined/set automatically (Constant Builder, Variable Builder, Argument Builder)
2. add prefix automatically for given type Constant Builder, (Variable Builder, Argument Builder and Fast Declare)
2.a Fast Declare: always start with prefixing,
2.b Add prefix for initial default type (e.g. str for String),
2.c Fix prefix after change of type