Index
Symbols & Numbers
/x command, 1
backslash (\), 396
Coolon (:), 396
data types
Boolean, 42
Byte, 42
Currency, 42
Date, 42
Double, 42
Integer, 42
Long, 42
Object, 42
Single, 42
String, 43
User-defined, 43
Variant, 43
forward slashes (///), 589
operators
. period, 24
<, 24
=, 24
>, 24
ternary operator (?), 47
underscore (_), 38
.Formula property, 379
.FormulaLocal property, 379
.reg file, 589
.wav file, playing, 357
.xls extension, 2
<Recording> descriptor, 630
<snapshot> descriptor, 630
absolute and relative recording, 7
absolute changes, 350
A
Access and DAO, 320
Access database to store errors, 610
access modifiers
Friend, 92
Private, 92
Public, 92
Access, Excel, and Outlook, 321
accessing controls in UserForms, directly, 171
ActionControl property, 544, 549
Activate and Select, 409
Activate event, 349
Activate method, 409
active properties, 76
Active Server Pages (ASP), 605
active Word document, accessing, 318
ActiveCell object, 32
ActiveCodePane property, 285, 303
ActiveConnection property, 213, 233, 480
ActiveSheet property, 647
ActiveVBProject property, 283, 299
ActiveWorkbook, saving, 394
ActiveX command button control, creating, 12
ActiveX Data Objects (ADO), 197, 320, 467
Add method, 45, 190, 394, 520, 556
Add Watch, 156
Add-in from the Add-ins List, removing, 252
Add-in Install event, 251
Add-in, installing, 250
Add-in. See Add-ins, creating and using Add-ins, creating and using, 245
Add-ins ...
Get Excel 2003 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.