cls files, and save cExcelUtils.cls.
Creating Wizard-Style Data Entry UserForms
Wizard-style entry is a fairly common technique used to help users enter data in long or complex
forms. Wizards allow you to break your data into related sections, allowing you to guide
the user through an orderly data entry process.
From the sample files for this book, open the file named HRWizard.xlsm. This file consists
of two worksheets. The employee database worksheet, named EmpData, is shown in
Figure 4-14.
Figure 4-14. The HRWizard.xlsm EmpData database worksheet
CHAPTER 4 n USERFORMS 150
The second worksheet, ListMgr, contains various lists we??™ll be using when we create our
wizard data entry form. Figure 4-15 shows the ListMgr worksheet.
Figure 4-15. The ListMgr worksheet contains list data for the wizard UserForm.
For reference, any column on the EmpData worksheet that references a list has a blue
color-coded column heading. Our EmpData worksheet data is divided into four sections:
Personal, Address, Equipment, and Access, as shown in Figures 4-16 through 4-19.
Figure 4-16. Employee personal information
Figure 4-17. Employee address information
CHAPTER 4 n USERFORMS 151
Figure 4-18. Employee equipment information
Figure 4-19. Employee access information
Our wizard UserForm will walk the user through entering this information for new
employees. In turn, each piece of information will be forwarded to the appropriate department
for processing.
Laying Out the Wizard Form
1.
Pages:
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169