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

14.3.5 Linking the Integrated Development Environment (IDE) Menu and the
Data
Figure 14.7 displays final UserForm layout for your tool. We are now ready to dig into the details about
how to link the data to the UserForm boxes and create variable values usable directly by VBA code
routines.
Figure 14.7: The Graphical User Interface UserForm Shown in the IDE.
Identify the Excel objects needed to be placed on the UserForm
Figure 14.7 is our main menu, so let's look at the menu layout (Figure 14.8) to examine the components on
the menu and how they will be used. We will identify each element in Figure 14.8, and describe each
control by its relative position as shown in the table below (as in TextBox1 or CommandButton2).