UEU-co logo

Category: Wiley Excel Power Programming with VBA

T

Index T /t filename switch, 74 Tab function, 986 tab order of controls, Properties window (VBE), 425 table style, 935 tabs color, 935 font, 935 TabStrip control, UserForms, 419 Tag property, UserForms, 443 Tan function, 986 tangent of numbers, 986 task pane, 29 templates creating, 82-83 defaults and, 82-83 introduction, 80-81 new, 934 viewing, 81-82 […]

U

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, […]

H

Index H headers, updating, 642 Help system associating files with application, 798 associating topics with functions, 798-799 cell comments, 784-785 creating, 125-126 Help file, displaying, 549-550 HTML files, 792-793 HTML Help, 794-797 introduction, 44-45 Loan Amortization Wizard, 808-809 MHTML files, 793-794 official Help system, 782 overview, 782 properties, 424 scrolling labels for help text, 789-790 […]

I

Index I icons, shortcut menus, 773-774 IDE, 859-860 IDE object model, VBProjects collection, 862-864 If-Then constructs, 221-225 If-Then-Else statement, 979 IIf function, 984 Image control Picture property, 526 UserForms, 417, 510-511 imageMso images, RibbonX code, 741 Immediate window (VBE) introduction, 141 procedures, 250-251 Implements statement, 979 Import method, 895 Import procedure, 897-898 ImportAFile procedure, 899-900 […]

J

Index J Join function, 984 Jon Peltier’s Excel Page Web site, 976

K

Index K Key is already associated with an element of this collection error, 992 keyboard Ribbon access, 24-25 shortcuts, 28 KeyDown event, 661 KeyPress event, 661 keystrokes, sending to active window, 981 keytips, 24 KeyUp event, 661 keywords Call, 244 Function, 279 Optional, 294 Rem, 192 Kill command, 830 Kill statement, 979 KillTheForm procedure, 455

L

Index L Label control Help system, 788-789 UserForms, 418, 517 labels, animating, 482-485 language elements assignment statements, 190 comments, 190 function, 190 introduction, 189-190 looping structure, 190 variable declaration statement, 190 variables, 190 language issues, 128 LastInColumn function, 366-368 LastInRow function, 366-368 LastPrinted function, 363 LastSaved function, 363 late binding, 679-680 Layout event, 661 LBound […]

M

Index M /m switch, 75 Macro Control functions, category, 308 Macro dialog box, procedures, 241 macro recorder absolute references, 159-162 charts and, 572-574 cleaning up recorded macros, 163-165 entering code and, 148-152 macro names, 162 recording, 158-159 relative references, 159-162 shortcut keys, 163 storing macros, 163 macro viruses, 939 macros CommandButton, 119 disappearing, 931 introduction, […]

N

Index N /n filename switch, 74 #N/A error, 60 Name command, 830 #NAME? error, 60 name extended property, 839 Name Manager dialog box, 53 Name statement, 980 Named argument not found error, 992 names cells, 53-54 charts, 579 columns, 55 constants, 56-57 existing references, 54 formulas, 57-59 intersecting, 55 introduction, 30-32 object class, 892 objects, […]

O

Index O Object Browser, events, locating, 655 object class, naming, 892 Object data type, 195, 978 Object doesn’t support current locale setting error, 992 Object doesn’t support named arguments error, 992 Object doesn’t support this action error, 992 Object doesn’t support this property or method error, 991 object hierarchy, 136, 165-166 object methods. See methods […]

F

Index F F4 function key, 933 File already exists error, 990 File already open error, 990 file associations, Windows API, 377-378 File not found error, 990 file structure, developers and, 13 file types accdb, 79 accde, 79 database files, 79 dbf, 79 dif, 79 htm (Hypertext Markup Language), 80 mdb, 79 mde, 79 mht (Single […]

G

Index G gaming, 102 General tab (VBE), 156-157 GenerateGrayScale procedure, 907 genre extended property, 839 Get not supported at runtime error, 991 Get not supported (write-only property) error, 991 Get statement, 979 GetAColor function, 523-524 GetAFolder function, 406-407 GetAllSettings function, 983 GetAttr command, 830 GetAttr function, 984 GetDate function, 323 GetDirectory function, 404-406 GetEnabled callback […]

B

Index B background color, shapes, 917-919 Bad DLL calling convention error, 990 Bad file mode error, 990 Bad filename or number error, 990 bad loops, 228 Bad record length error, 990 Bad record number error, 990 BASIC (Beginner’s All-purpose Symbolic Instruction Code), 134 BatchProcess function, 354-355 Beep statement, 977 BeforeClose event, 637, 643-645 BeforeDoubleClick event, […]

C

Index C CalcComm procedure, 291 Calculate event, 603, 645, 654 Calculation mode, 48 Calculation property, 933 Call keyword, 244 Call statement, 977 callback procedures CheckPageBreakDisplay, 744 description, 736 GetEnabled, 744 GetPressed, 744 Initialize, 743-744 RibbonX code, 739-740 TogglePageBreakDisplay, 744 CallByName function, 982 calling procedures, 238 camera model extended property, 839 Can’t create necessary temporary file […]

D

Index D 3-D effects in charts, 591-592 Daily Dose of Excel Web site, 976 DAO (Data Access Objects), developers and, 13 data analysis, developers and, 13 data entry introduction, 30 next empty cell, 323-324 overview, 102 validation, 648-651 data forms, displaying, 410-411 data labels, charts, displaying, 598-600 data storage, 106 Data tab (Ribbon), 728 data […]

No related posts found…

Categories

apply_now Pepperstone Group Limited