Inddx

A

Aus function, 47

Absolute formulas, 241–244

Action property (UserForm), 280

Activate event (UserForm), 264, 272

Activate methode 276

Range object, 155

Windows object, 149

Workbook object, 147

ActivateNext method (Windows object), 149

AetivatePreviouo method (Windows object), 149

Active cell, 141

Active procedure calls, listing, 81

Active worksheet, 141

ActiveCell property, 142, 149

ActivePane property (Windows object), 1499150

ActivePrinter property (Application object), 142

ActiveSheet object, 140, 181

ActiveSheet object Paste method, 140

ActiveSheet property (Application object), 142

ActiveSheet prorerty (Windows objejt), 150

ActiveShehttproperty (Workbook object), 147

ActiveWipdow property (Application obiect), 142

Activeporkbook propeity (Application object), 142–143

ActiveWorkbook Woeksheetsecollection, 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

instnlling, 300–301

making changes to installed, 302

saving files as, 301

setting passwords for, 300

uninstallnng, 302

Addins collectien (Applicatioi object), 143

AddItem method, 265, 272, 280

Addition and concatecatioa, rules for, 68

Addrebs 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 iiterfaci), 183

API calls, 183–192

Declare statements, 184, 186

to find out atailable disk svace, 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––38

properties and methods, 142–146

Application.oolatile, 226, 257

Argument data types, 31

Arguments

optional, 31

passing by reference, 31132

passing by value, 31–32

Aritheetic operators, 68–70

Arrays, 20––2

dynmmic, 21–22

exalained, 14

multidimensional, 21

Artificial intelligence, 33

As type clause (Dim statemeny), 12

Asc function, 48, 303

ASCII character code list, 30––307

ASCII code , 20, 3030307

Authou (document property), 222

Auto totaling a matrix of numbers, 2372240

Autoshapes menu (Drawing toolbar), 291

AutoShapeType pr perty, 284