17.

A

absolute references

designating, 115

overview, 109-10

accelerator keys, 238. See also Accelerator property

Accelerator property

CheckBox object, 231

CommandButton object, 236

OptionButton object, 229

Activate method

ChartObject object, 83

Range object, 97-98

Worksheets object, 66

active cell

designating in ranges, 95-97

vs. selected cells, 112

ActiveCell object, 39

ActiveCell property, 98

ActiveChart object, 80

ActiveSheet object, 64

ActiveSheet property, 64

ActiveWindow object

CutCopyMode property, 17

DisplayGridlines property, 14

ActiveWorkbook object, 62

active worksheets. See ActiveSheet object

ActiveX controls, Control Toolbox

AddDates macro, 38-40

AddFields method, 128-30

Add method

for collections, 251

Workbooks object, 58

Worksheets object, 64-65

addresses, cell

A1-style vs. R1C1 style, 110-11

building formulas by referencing, 114-16

relative vs. absolute, 115

Address property, 116

AddShape method, 72

Add View dialog box, 240

ampersand (&), 115

animation

bypassing, 258

creating logo, 281-84

in macros, 281-84

stopping, 258

viewing, 256

AppendDatabase macro, 40-43

Application object

Caller property, 279

DisplayAlerts property, 47

GetOpenFilename method, 32

StatusBar property, 159

applications. See also EIS)

changing window size, 287-89

packaging, 284-91

replacing menu bar, 284-86

replacing toolbars, 290-91

arguments

for custom functions, 165-67

making optional, 168-69

for methods, 17

overview, 17

vs. properties, 18

Array function, 129

assignment statements, 152

Auto List feature, 83

Automation, 2-3

Auto Quick Info feature, 32

autos. See cars

axes, chart, 87