Skip to Content
Excel VBA Programming For Dummies, 6th Edition
book

Excel VBA Programming For Dummies, 6th Edition

by Dick Kusleika
February 2022
Beginner to intermediate content levelBeginner to intermediate
432 pages
9h 21m
English
For Dummies
Content preview from Excel VBA Programming For Dummies, 6th Edition

Index

A

  • Abs function, 142
  • absolute mode, macro recorder, 86–87
  • Accelerator property, UserForm controls, 284
  • Activate event, 173
  • activation events, 181–184
  • active objects, 15
  • Add Watch dialog box, 215
  • add-ins
    • adding description, 372–373
    • creating, 374
    • customizing with macros, 12
    • defined, 365–366
    • distributing, 375
    • modifying, 375–376
    • opening, 374–375
    • overview, 368–369
    • protecting VBA code, 373
    • reasons to create, 366–367
    • setting up workbook, 369–372
    • testing workbook, 372
    • working with, 367–368
  • Add-ins Ribbon tab, adding commands to, 338–339
  • AddItem method, ListBox control, 310
  • Addition operator, 114
  • Address property, Range objects, 126–127
  • And operator, 115
  • Application object, 53–56
  • arguments
    • defined, 60
    • GetOpenFilename statement, 257
    • GetSaveAsFilename method, 259
    • worksheet functions
      • no-argument functions, 349
      • optional arguments, 354–356
      • overview, 348
      • range argument, 352–354
      • single-argument function, 349–351
      • two-argument function, 351–352
  • Array function, 142
  • arrays
    • declaring, 116–117
    • defined, 116
    • dynamic, 117–118
    • MonthNames function, 359–360
    • multidimensional, 117
    • SORT function, 360–361
  • assignment statements
    • equal sign operator, 114
    • logical operators, 115
    • operator precedence, 114–115
    • overview, 113–114
    • smooth operators, 114–116
  • Auto Data Tips option, VBE Editor tab, 46
  • Auto Indent setting, VBE Editor tab, 46
  • Auto List Members feature, VBE, 45, 64–65
  • Auto Quick Info option, VBE, 46
  • Auto Syntax Check, VBE, 44, 387–388
  • automatic event procedures. See events
  • AutoSize property, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel VBA Programming For Dummies, 5th Edition

Excel VBA Programming For Dummies, 5th Edition

Michael Alexander, John Walkenbach

Publisher Resources

ISBN: 9781119843078Purchase Link