Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft))

A

A1 reference style, 119

Accounting format, 5

Accounting Number Format button, 5

Activate method, 82, 88

active workbook, referencing, 82

ActiveCell object, 53

ActiveCell property, 104–105

column selection with, 105

ActiveSheet, 46

ActiveX controls. see also command buttons

defined, 264

vs. Forms controls, 268

Add method, 71, 75

Name argument, empty string for, 157

Source value, 144

value returned by, 86

AddDataField method, 160

adjustment handles on shapes, 190, 191

animations, 336

arguments

defined, 27

displaying all for method. see Auto

Quick Info

for functions, adding, 240–242

for functions, making optional, 243–244

naming, 27

parentheses around, 218, 219

for PasteSpecial method, 27

syntax in macros, 27

Array function, 88

attributes. see properties

Auto List Members, 45, 74

for worksheets, activating, 89–90

Auto Quick Info, 45