Index_U

---

U

UBound function, 185, 186

Underline property, 232

UnderlyingValue property, 494

underscore (_), displaying on a drop-down button, 414

Undo function, not available for databases, 480

unfilled circles, chart handles displayed as, 323

Ungroup item on the Format menu, 46

Unhide dialog box, 150

Union method, 173

Unlink method, 543

Unlist method, 543

Unload method, 399

Unload routine, 504

Unprotect method

of ActiveWorkbook, 144

of ActiveWorksheet, 159

unsaved changes, tracked by Excel, 141

untrapped errors, entering Break mode on, 52

unused worksheets, removing, 116

Up Arrow key, 127

Update method, 492, 493

update procedures, placing in a module, 97

Update statement, 471, 479

UpdateChanges method, 543

UpdateLinks parameter, 130

upper boundary for an array, 65

URL

to connect a Web data source, 352

encoding, 536

including the parameters as part of, 536

of the SharePoint list for a ListObject object, 542

U.S. Treasury Web site, 527

user form controls, 401-17

accepting the focus, 403

adding to user forms, 401, 421

examining the contents of, 403

placing on user forms, 421

properties, controls, methods and events of, 402-4

user form module, validating data in, 429-30

user forms, 42, 419

adding, 395

constructing, 419-31

creating, 395-400, 420

creating advanced, 419-41

designing, 51, 383, 396, 420-22

displaying, 399-400, 430

executing, 48

inserting into current projects, 45

life cycle of, 400

loading, 399

marking as dirty, 427

modifying, 397

moving controls to frames, 408

moving to the last line in, 426

placing on the screen, 398

properties of, 399

selecting, 397

testing, 397

typing data into, 187

User Id keyword, 486

UserForm events, 265

UserForm item on the Insert menu, 45

UserForm object, 395

adding to a project, 395

building for a wizard application, 434

creating, 396, 398, 420

UserForm_Initialize event, 502

creating, 426

in Excel Query program, 506

setting the LastRow variable in, 427

UserForm_Terminate event, 506

UserInterfaceOnly parameter, 158

user-level permissions, 7

users

accepting input from, 67, 71-72

accepting text responses from, 71

allowing to select multiple files, 294

allowing to unprotect worksheets, 159

choosing from a range of numeric values, 407

code prompting to save workbooks, 272

displaying a list to, 412

interfacing with, 400

performing selective validation of input, 121

presenting with messages, 67

preventing from accessing shortcut menus, 276

prompting for values, 122

selecting a range of cells from a workbook, 415

UseSystemsSeparators property, 529

UsingLateBinding procedure, 450

utf-8 encoding scheme, 547

utf-16 encoding scheme, 547

utility, designing to search for files, 287

---