Excel VBA Macro Programming

A

Abs function, 47

Absolute formulas, 241 ‚ 244

Action property (UserForm), 280

Activate event (UserForm), 264, 272

Activate method, 276

Range object, 155

Windows object, 149

Workbook object, 147

ActivateNext method (Windows object), 149

ActivatePrevious method (Windows object), 149

Active cell , 141

Active procedure calls, listing, 81

Active worksheet, 141

ActiveCell property, 142, 149

ActivePane property (Windows object), 149 ‚ 150

ActivePrinter property (Application object), 142

ActiveSheet object, 140, 181

ActiveSheet object Paste method, 140

ActiveSheet property (Application object), 142

ActiveSheet property (Windows object), 150

ActiveSheet property (Workbook object), 147

ActiveWindow property (Application object), 142

ActiveWorkbook property (Application object), 142 ‚ 143

ActiveWorkbook Worksheets collection, 265

ActiveX Data Objects Library, 179

ActiveX Data Objects Recordset Library, 179

Add (+) operator, 68 ‚ 69

Add Procedure dialog, 195

AddComment method, 156, 283

Add-ins

class modules as, 193

creating, 295 ‚ 302

installing, 300 ‚ 301

making changes to installed, 302

saving files as, 301

setting passwords for, 300

uninstalling, 302

Addins collection (Application object), 143

AddItem method, 265, 272, 280

Addition and concatenation, rules for, 68

Address property (Range object), 156

ADO (ActiveX Data Objects), 179

referencing, 179 ‚ 180

using, 179 ‚ 181

After parameter (Move method), 230

And operator, 36, 71 ‚ 72

Animation, 199 ‚ 201

Animation object, setting up, 200

Animation property (balloon), 289

API (application programming interface), 183

API calls, 183 ‚ 192

Declare statements, 184, 186

to find out available disk space, 184 ‚ 185

for reading keyboard activity, 187 ‚ 192

for reading and writing to INI files, 185 ‚ 187

AppActivate command, 61 ‚ 62

Application object, 141 ‚ 146

caption property, 85

in hierarchy, 136 ‚ 138

properties and methods , 142 ‚ 146

Application.volatile, 226, 257

Argument data types, 31

Arguments

optional, 31

passing by reference, 31 ‚ 32

passing by value, 31 ‚ 32

Arithmetic operators, 68 ‚ 70

Arrays, 20 ‚ 22

dynamic, 21 ‚ 22

explained, 14

multidimensional, 21

Artificial intelligence, 33

As type clause (Dim statement), 12

Asc function, 48, 303

ASCII character code list, 303 ‚ 307

ASCII codes, 20, 303 ‚ 307

Author (document property), 222

Auto totaling a matrix of numbers , 237 ‚ 240

Autoshapes menu (Drawing toolbar), 291

AutoShapeType property, 284