U
Undo method (Application object), 146
Unprotect method (Worksheet object), 155
User Defined Formula, on Formula toolbar, 257
User-defined variable data types, 22 ‚ 23
UserForm
activate event, 264
as an object, 91
BackColor property, 94
code window for, 95
Common Dialog control on, 245 ‚ 246
displaying in code, 97
Font property, 94
Hide method, 97, 242, 260
Initialize event, 95, 97
inserting, 91
list box on, 100
mouse and keypress events, 96
MouseMove event, 96
placing controls on, 97
populating, 97
preparing, 92
for providing graphic comments, 277 ‚ 284
for a search facility, 269 ‚ 270
for setting global values, 260
setting up the GUI interface, 243 ‚ 244
Show method, 97, 243
viewing, 95 ‚ 96
for viewing hidden sheets, 263 ‚ 267
UserForm properties, 92 ‚ 94
UserForm properties window, 91
UserForm_Activate event, 272
UserForm_Terminate event, 272
UserName property (Application object), 146