O


Object Browser, 76

components of, 95

hidden members, displaying, 187

Object Browser button, 94

object classes

browsing, with Object Browser. see

Object Browser

defined, 69

instances, 71

members, 71

methods of, 70. see also methods

properties of, 70. see also properties

object model

defined, 3

languages communicated with, 4

VBA interface with, 3

objects

ActiveCell, 53

Borders, 129

Chart, 203

CustomView, 320

in collections. see collections

defined, 3, 67, 68–69

Err, 252–253, 258

FillFormat, 183, 206

graphical. see graphical objects

hidden, 187

members, viewing list of, 178

PivotCache, 156

properties. see properties

Range, 107–111, 132

repeated, consolidating, 21–22

returned by properties, finding, 183

selecting multiple, 200

Selection, 53

Shape, 188

ShapeRange, 188

Shapes, 188

specifying, 11

syntax in macros, 26–27

for user forms, 311

UserForm, 311

Workbook, 320

WorkbookConnection, 157

Workbooks, 73, 77–78, 83

Worksheet, 97

Worksheets, 84–85, 97

Office Fluent user interface, xiii

Offset property, 109–111

On Error Resume Next statement, 249–251

Open dialog box, displaying with macro, 46

OpenText statement, 43

option buttons

adding to forms, 307, 325–327

aligning, 308

captioning, 307

defined, 306

Option Explicit statement, 246

optional arguments, 243–244. see also arguments



Microsoft Office Excel 2007 Visual Basic for Applications Step by Step
Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft))
ISBN: 0735613591
EAN: 2147483647
Year: 2004
Pages: 99
Authors: Reed Jacobsen

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net