Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

Object Browser, events, locating, 655

object class, naming, 892

Object data type, 195, 978

Object doesn't support current locale setting error, 992

Object doesn't support named arguments error, 992

Object doesn't support this action error, 992

Object doesn't support this property or method error, 991

object hierarchy, 136, 165-166

object methods . See methods

object model, 16, 134-135

Object or class does not support the set of events, 992

object properties. See properties

Object required error, 991

Object variable or With block not set error, 991

object variables

Dim statement, 211

Public statement, 211

objects

active, 137

examples, 15-16

FileDialog, 403, 406-407

hierarchy, 16

importing/exporting, Project Explorer, 143-144

introduction, 136

listing, 948

locking, 123

methods, 137, 185, 894

names , 59

parents, 364-365

properties, 137, 185, 892-894, 981-982

range objects, 16

referring to, 167

removing from memory, 981

selecting, 32-33

workbook objects, 16

obResizer_MouseMove event handler, 518

Oct function, 985

octal, converting from decimal, 985

Offset property, 184-185

OKButton_Click procedure, 475-476

OLE (Object Linking and Embedding)

Automation objects, 984

description, 677

object creation, 982

On Error statement, 256, 980

one-dimensional arrays, transferring, 339

On GoSub statement, 980

On GoTo statement, 980

OnKey event

example, 664-665

key codes, 666-667

shortcut menus , disabling, 667-668

online help. See Help system

online resources

Help system, 971

Internet newsgroups, 973-975

Microsoft Technical Support, 972

Web sites, 975-976

OnTime event, 662-664

Open event, 638, 639

Open statement, 842, 980

OpenTextFile procedure, 673

OpenURL procedure, 673

operating environment strings, 983

operators

+ (addition), 208

& (concatenation), 208

/ (division), 208

= (equal to), 208

ˆ˜ (exponentiation), 208

> (greater than), 208

>= (greater than or equal to), 208

< (less than), 208

<= (less than or equal to), 208

* (multiplication), 208

<> (not equal to), 208

“ (subtraction), 208

And, 209

comparison, 208

Eqv, 209

Imp, 209

logical, 209

Not, 209

Or, 209

Xor, 209

Option Base statement, 980

Option Compare statement, 980

Option Explicit statement, 938, 980

Option Private statement, 980

optional arguments, functions, 294-295

Optional keyword, 294

OptionButton control

interactive charts , 625

properties, 431

UserForms, 418

orientation, 935

Orientation property, DataPivotField object, 563

Out of memory error, 989

Out of stack space error, 990

Out of string space error, 989

outlines, 42

Outlook, sending messages, 687-690

output, positioning, 986

Overflow error, 989

owner extended property, 839