Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

UBound function, 267, 986

UCase function, 271, 987

UI ( user interface)

contextual tabs, 21

developers and, 13

dialog boxes, custom, 117-118

Ribbon, 20-25

Ribbon, customizing, 114

shortcut keys, 116-117

shortcut menus , 116

unlinked charts , creating, 613-615

Unload command, 428

Unload statement, 981

UnzipAFile procedure, 858

unzipping files, 858

UpdateBox procedure, 489-490

UpdateChart procedure, 594

UpdateDynamicRibbon procedure, 754

UpdateProgress procedure, 498

updates to applications, 127-128

UpdateSheet procedure, 245

updating, modules, 867-869

uppercase, converting string to, 987

User Defined functions, category, 308

user entry, validating, 322

user interface. See UI (user interface)

User interrupt occurred error, 990

UseRandomColors procedure, 928

User-defined data type, 195

user-defined data types, 212-213

UserForm1 code module, Text Tools utility

ApplyButton_Click procedure, 543

CloseButton_Click procedure, 543

ComboBoxOperation_Change procedure, 543

HelpButton_Click procedure, 543

UserForm_Initialize procedure, 542

UserForm object, Show method, 427

UserForm_Initialize procedure, 459-460, 807-808

UserForms. See also custom dialog boxes

Activate event, 438, 661

ActiveX controls, 118

ActiveX controls, new, 447

Add100Buttons procedure, 874-875

AddControl event, 661

BeforeDragOver event, 661

BeforeDropOrPaste event, 661

buttons , 100, 874-875

Caption property, 431

charts, displaying, 524-526, 959

CheckBox control, 416

checklist, 448

Click event, 661

Close button, disabling, 456

closing, 428-429

color , selecting, 523-524

ComboBox control, 416

ComboBox control, Help system, 790-792

CommandButton control, 417, 450

controls, 118

controls, adding, 415-416

controls, adding at design time, 872-875

controls, adjusting, 421-422

controls, aligning, 421

controls, movable, 510-511

controls, referencing, 444-445

creating, 414, 430-433

creating programmatically, 875-883

data validation, 436

DblClick event, 661

Deactivate event, 438, 661

design-time manipulations, 872-875

dialog boxes and, 27

displaying, 427-428

displaying based on variable, 428

displaying charts, 600-602

displaying, code for, 433

displaying modeless, 427

dynamic creation, 878-883

Error event, 661

event-handler procedures, 429-430

event-handler procedures, adding, 435-436

events, 437-439, 631, 661-662

events, keyboard-initiated, 440-441

events, mouse-initiated, 440

events, SpinButton controls, 439-440

external controls, 480-482

Frame control, 417

GetOption function, 878-881

grid lines, 421

Help system, 784, 788-792

hiding, 960

Image control, 417, 510-511

Initialize event, 438, 661

input, 118

inserting, 414-415

KeyDown event, 661

KeyPress event, 661

KeyUp event, 661

Label control, 418, 517

Layout event, 661

ListBox control, 418, 450-451

loading, 428

MakeForm procedure, 876-877

maximum size , 516

menus, 450-451

minimum size, 516

MouseDown event, 661

MouseMove event, 661

MouseUp event, 661

MultiPage control, 418, 479-480

multiple controls, one event handler, 520-522

OptionButton control, 418

overview, 413

progress indicator, MultiPage control and, 497-498

progress indicator, standalone, 493-494

puzzle, 529-530

QueryClose event, 439, 661

ranges, selecting, 452-453

RefEdit control, 418, 452-453

RemoveControl event, 661

resizable, 515-519

Resize event, 661

run time creation, 876-877

run time manipulations, 872-875

Scroll event, 661

ScrollBar control, 418

shapes , 961

size, 457-458

SpinButton control, 419

splash screens, 454-455

TabStrip control, 419

Tag property, 443

templates, creating, 447-448

Terminate event, 439, 661

testing, 434-435

Text Tools utility, 538

Text Tools workbook, 537

TextBox control, 419

title bar, none, 511-513

Togglebutton control, 419

toolbar simulation, 513-515

unloading, 960

worksheets, scrolling, 458-460

worksheets, zooming, 458-460

Zoom event, 661

UserInterfaceOnly option, 939

user-oriented applications, 801-802

users

description, 100-101

experience, 100-101

input, prompting for, 984

needs determination, 110-111

utilities

introduction, 533-534

qualities of good, 535

VBA for development, 534

utility applications, 105