Add parameters to a procedure efficiently using Code VBA

Another use for the Variable menu is for inserting parameters for procedures:

1. Put the cursor in the position in the procedure header where you want to add a parameter;
2. Start the variable continuations menu using Shift-Space;
3. Select the type and Enter;
4. Type the name of the parameter.

Additional parameters

If you enter a comma , after a parameter, the continuations menu starts automatically allowing you to insert a new one.

Adding Optional parameters

To insert Optional parameters use the above procedure but select submenu Optional (at the bottom) first.