UEU-co logo

U


Previous Page

Next Page

Index

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

Previous Page

Next Page

Leave a Reply


Time limit is exhausted. Please reload the CAPTCHA.

Categories

apply_now Pepperstone Group Limited