The Excel Object Model in Detail

ByRick

We had an earlier post, How to Use Objects, Collections, Properties, Events and Methods in Excel Visual Basic.  There, we introduced the idea of Objects and Collections.  We listed the most useful Objects, and Collections of Objects.  Below we have more extensive diagrams, specifically for the Excel Object Model.  It helps to understand the hierarchy: This lets you address an object at any level.  For example, Application.Workbook.Range.Font.

The diagrams below come from earlier Visual Basic Help, back when Help was truly helpful.

Everything branches off from the Application.  Worksheets and Charts have their own sections below that for Application.

White blocks represent an Object only (such as “Application”).  Yellow blocks have an object and a collection.  Thus, the block “Workbooks (Workbook)” represents the Workbooks collection.  In this, the individual object is the Workbook.

1.           Application

2.           Worksheets

3.           Charts

Not shown here, are the trees for Shapes and Chart Groups.

Similar Posts

|

How to Store Program Settings in the Registry from Excel Visual Basic

ByRick

Windows stores program settings in the Registry, a Windows internal database.  You can use this to remember previous user choices and use them as defaults the next time.  We typically remember window positions, file paths, and other settings with the Registry. These three commands work with items stored in the Registry: SaveSetting appname, section, key,…

|

Useful Keywords to Know in Excel Visual Basic

ByRick

1.        The Application Keyword Use “Application” to refer to Excel, e.g.: Application.ActivePrinter Name of the Active Printer.Application.Name            Name of the program running (“Microsoft Excel”).Application.Path            The path from which the program is running. 2.        ActiveControl Instead of the name of a specific control (e.g. txtEdit), you can use the keyword ActiveControl.  This will let your program refer…

|

How to Pass Arguments Efficiently in Visual Basic

ByRick

This is from Microsoft Excel 2000 Visual Basic Help, with changes and additions. All arguments are passed to procedures by reference, unless you specify otherwise. This is efficient because all arguments passed by reference take the same amount of time to pass and the same amount of space (4 bytes) within a procedure regardless of…

|

FORMULATEXT to Display the Formula in a Cell

ByRick

Here is a function that displays the formula in another cell: FORMULATEXT(reference). The argument, “reference”, is the cell address that contains the formula you want to display. This is most useful for documentation purposes.  For example, when you want to print out a spreadsheet with its formulas. If you have spent much time on this…