Procedure Call Builder

The Procedure Call Builder (see recording below) is a powerful tool available for all built-in procedures that have more than 1 argument. It makes it easy to insert the correct code in several ways. It provides direct access to information from the MS VBA documentation, and lets you select appropriate objects and values for arguments. The example below shows: from the Excel VBA menu move to the Worksheet class and select Add ... (for Sheets or for Worksheets). This opens the Procedure Call Builder. Next,

• At the top of the dialog is explanation on what the procedure does
• Select which workbook the worksheet needs to be added to (choose (New)wb As Worbook to declare a new workbook variable, if that is what you want)
• Because this procedure returns a worksheet and there is no worksheet variable to return the newly created object in, the Return variable combo is filled with a proposed (New)ws As Worksheet variable.
• Moving through the procedure's arguments at the bottom of the lisit text appears explaining what the argument does.
• Optional arguments can be recognized as having round brackets. Such arguments need not be specified.
• If available, the default value is also mentioned between the brackets
• If a list of possible values is available, you can choose from it using the argument combo box popup.
• Optional arguments can be recognized as having round brackets. Such arguments need not be specified.
• By checking the With box the Workbook class object can be used for other actions