Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Handheld Computing
Hardware
Money Management Software
Multimedia
Office Productivity Software
Operating Systems
Moms, Dads, and Grads -- Win $500!
Excel VBA Programming For Dummies
The Excel Object Model in VBA
Adapted From: Excel VBA Programming For Dummies

You can manipulate practically every aspect of Excel by using Visual Basic for Applications (VBA). Each item in Excel -- each spreadsheet, dialog box, command, and individual cell -- is an object. (Excel itself is even an object in VBA!) All of these objects are arranged in a hierarchy that is known as the Excel object model.

Excel’s Help system can display the complete Excel object model graphically. How you open this diagram varies a little depending on the version of Excel you have. To see all the objects you can manipulate and/or access with VBA for Excel 2003, follow these steps:

  1. Activate the VBE either by choosing Tools, Macro, Visual Basic Editor or by pressing Alt+F11.

  2. Type Object Model in the Help box (located to the right of the menu bar). The Search Results appear in the task pane.

  3. Click Microsoft Excel Object Model.

What you’ll see is a picture of the hierarchy of objects in the Excel object model, with Application as the overall parent object. It can help to think of this object model as a folder structure on your Desktop, but with one difference: Each folder does more than just hold other items; each folder is a useful, pliable, changeable piece of Excel.


To find out how to have Dummies eTips delivered to your e-mail inbox every week, visit the Dummies eTip Sign-Up Page.
Related Articles
Password-Protecting Your Crystal Xcelsius Dashboard
Setting Task Duration in Microsoft Project 2007
Excel 2007: Getting the Right Numbers with AVERAGE, MAX, MIN, and MEDIAN
Using Time Functions in Excel 2007
Finding the Correct Excel Function
Related Titles
Excel 2000 For Windows For Dummies
Excel 2000 for Windows For Dummies: Quick Reference
Excel 2002 For Dummies
Excel 2002 for Dummies: Quick Reference
Excel 2003 Power Programming with VBA