SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 160 | Next

Jim DeMarco

"Pro Excel 2007 VBA"


Table 4-6. Equipment Tab Control Settings
Item/Property Value
Frame ??”
Name: fraPCType
Caption: Computer Type
OptionButton ??”
Name: optDesktop
Caption: Desktop
OptionButton ??”
Name: optLaptop
Caption: Laptop
Frame ??”
Name: fraPhoneType
Caption: Phone Type
OptionButton ??”
Name: optStandard
Caption: Standard
OptionButton ??”
Name: optCell
Caption: Cell Phone
Label ??”
Caption: Location
ComboBox ??”
Name: cboLocation
CheckBox ??”
Name: chkFaxYN
Caption: Fax Machine Y/N
Page3 in Design view will look something like Figure 4-25.
CHAPTER 4 n USERFORMS 158
Figure 4-25. Equipment information data entry on Page3
The Access Information Page
Add the controls listed in Table 4-7 to Page4 of the MultiPage control. These will correspond to
the access information column headings on the EmpData worksheet.
Table 4-7. Access Tab Control Settings
Item/Property Value
Label ??”
Caption: Network Access Level
ComboBox ??”
Name: cboNetworkLvl
Label ??”
Caption: Remote Access Y/N
ComboBox ??”
Name: cboRemoteAccess
Label ??”
Caption: Assigned Parking Spot
ComboBox ??”
Name: cboParkingSpot
Frame ??”
Name: fraBuilding
Caption: Building
Continued
CHAPTER 4 n USERFORMS 159
Table 4-7. Continued
Item/Property Value
OptionButton ??”
Name: optNYC
Caption: NYC
OptionButton ??”
Name: optNJ
Caption: NJ
Page4 in Design view should look similar to Figure 4-26.
Figure 4-26. Access level information data entry on Page4
That??™s it for visual UI design.


Pages:
148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172