O

Object Browser, 150, 155-160, 163, 164, 171, 205, 226 FileSystem object and, 288 opening, 155 Object data type, 175, 205 Object definitions, 151 Object library, 156

Object Model chart, 157 Object module, 28, 211

Object-oriented programming, VBA and, 150-151 Objects, 149

defined, 151-153 working with, 173-177 Office library, 156

Office programs, security levels for, 3 OLEObjects collection, 436-438 OLEObjects collection object, 184, 471 OnAction property, of Shape object, 435 One-dimensional arrays, 111-114 On Error statement, using, 271 OnKey() method, 443, 447

Open dialog box, 359, 360

Open() event, of Workbook object, 167, 182, 183

Open statement, 282, 289, 296

OpenXMLFile() procedure, 359, 360

OpenXML() method, of Workbooks collection object, 344

Operating system (OS) files, 280

Operator execution, parentheses and, 92

Operators, generating in Math Game program, 138-140

Optional keyword, 198

Option Button control, 80, 216, 266

in Math Game program, 134, 135, 136 Option Explicit statement, 28 Option Private statement, 60 Options dialog box, in Excel, 222, 223 OR operator, 69

truth table for, 70 Output, with MsgBox() function, 41-42 Overflow errors, 31 Overwrite argument, 348, 358

Biorhythm Awareness

Biorhythm Awareness

Who else wants to take advantage of biorhythm awareness to avoid premature death, escape life threatening diseases, eliminate most of your life altering mistakes and banish catastrophic events from your life.

Get My Free Ebook


Post a comment