Skip to Main Content
Excel 2003 VBA Programmer's Reference
book

Excel 2003 VBA Programmer's Reference

by Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg
July 2004
Beginner content levelBeginner
1176 pages
27h 45m
English
Wrox
Content preview from Excel 2003 VBA Programmer's Reference

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

Actions class, 575, 587

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 controls, 3, 12, 184

ActiveX Data Objects (ADO), 197, 320, 467

ActiveX DLLs, 260, 575

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel 2007 VBA Programming with XML and ASP

Excel 2007 VBA Programming with XML and ASP

Julitta Korol
Microsoft® Office Excel 2003 Programming Inside Out

Microsoft® Office Excel 2003 Programming Inside Out

Curtis Frye, Wayne S. Freeze, Felicia K. Buckingham
Excel® 2007 VBA Programmer's Reference

Excel® 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Access™ 2007 VBA Programmer's Reference

Access™ 2007 VBA Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey Griffith, Armen Stein

Publisher Resources

ISBN: 9780764556609Purchase book