Excel VBA Macro Programming

U

UBound function, 22

Ucase function, 45, 230

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