Info

events. See also names of individual events accessing from VBA Object and Procedure drop-down, 141-142 enabling, 142 parameters, 142 trapping, 416-419 formula-based conditions,

220-224 help, 33-35 loops directory files, looping through, 115-116 Do...Loop, 108, 110-111 Do...Until, 111-112 Do...While, 111-112 For...Each, 113-114 For...Next, 103-108 While...Wend, 113

methods, 30-33, 37 names arrays, 136

checking existence of, 138

creating, 132-133 deleting, 134 formulas, 134 global names, 131 hiding, 138 local names, 131 named ranges for

VLookups, 139-140 Names collection, 133 numbers, 136 overwriting, 133 reserved names, 137-138 strings, 135-136 object properties, 30-33,

41-42 pivot tables, creating, 238-240 limitations, 241 sums of revenues,

240-241 table size, 241-243 ranges, 61

cells, selecting, 71-73 creating from overlapping ranges, 69 empty cells, checking for, 69-70 joining, 68-69 named ranges, 62-63 non-contiguous ranges, 74

offsetting, 65-66 referencing in other worksheets, 63 referencing relative to other ranges, 63-64

referencing with Offset property, 65-66 resizing, 67 selecting with Cells property, 64-65 selecting with CurrentRegion property, 70-71 shortcuts, 62 specifying with Columns and Rows properties, 68

specifying with top-left and bottom-right corners, 62 recorded macro code, examining, 36-37 constants, 37-41 optional parameters, 37 properties, 41-42 statements Do, 108-111 Exit For, 107 For, 103-105 Next, 103-105 Step, 106-107 To, 104 Until, 111-112 Wend, 113 While, 111-112 With...End With, 56 syntax, 30-33 variables, 55, 113-114 VBE (Visual Basic Editor) add-ins, converting files to, 499-500 debugging techniques,

44-50 digital signatures, enabling, 19 Object Browser, 51-52

options, 18

Programming window,

22-24 Project Explorer, 19 Properties window, 20 recorded macro code, examining, 36-42 Visual Basic toolbar, 13-14 Web queries, 331-336

VBA Object and Procedure drop-down menu, 141-142

VBAProject Properties command (Tools menu), 502

VBE (Visual Basic Editor)

add-ins, converting files to,

499-500 debugging techniques backing up/moving forward in code, 45 breakpoints, 44-45, 50 hovering, 48 Immediate window,

45-48 running to cursor, 45 stepping through code,

42-45 watches, 48-50 digital signatures, enabling, 19

Object Browser, 51-52 options, 18

Programming window,

22-24 Project Explorer, 19 Properties window, 20 recorded macro code, examining, 36-37 constants, 37-41 optional parameters, 37 properties, 41-42

verifying form field entries, 170

Very High security (macros), 14

VideoRes() function, 457 View menu commands

Project Explorer, 19 Toolbars, 13

Visible property (names), 138

Visual Basic command (Toolbars menu), 13

Visual Basic Editor button (Visual Basic toolbar), 13 Visual Basic Editor. See VBE

Visual Basic for

Applications. See VBA Visual Basic toolbar, 13-14

VLOOKUP function, 139-140

0 0

Post a comment