Create an Excel Workbook That Runs SAS Programs - Exchanging Data Between SAS and Microsoft Excel - page 249

Figure 14.18: Excel VBA Code to Start the UserForm1 Software When Excel Starts.

The process of initializing the UserForm is a multi-step process that requires several types of actions. The
following is a list of the type of actions required for setup. Some actions are passive, which means they are
set up when the UserForm is built. Other actions must be coded to occur when the workbook opens and the
UserForm executes.

UserForm Initialization Processing

Initialization
Type

Field Function Source

Passive Year Part of directory path Control Source cell

Passive Month Part of directory path Control Source cell

Passive Work directory Full work directory path Control Source cell

Passive Build Code Only Boolean flag Control Source cell

Active Program ID Program ID value Loaded into ComboBox

Active Program Name Program name value Loaded from selected

worksheet

Active Unique Parameters Unique run-time parameters Loaded from selected

worksheet

14.4.1.2 Initializing Passive UserForm Values
Passive parameters are set up when the UserForm is designed. Figure 14.19 shows how the year value is
assigned to the worksheet named “Control_Info” in cell A2. If something is typed into the TextBox1 area
of the UserForm when the tool is running, the value is placed directly into cell A2 of worksheet
Control_info.