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 |