U


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



Excel 2007 Power Programming with VBA
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
ISBN: 0470044012
EAN: 2147483647
Year: 2007
Pages: 319

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net