If you've dealt with computers for any length of time, you've undoubtedly heard the term object-oriented programming. An object essentially represents a software element that a programmer can manipulate. When using Excel, you may find it useful to think in terms of objects, even if you have no intention of becoming a programmer. An object-oriented approach can often help you keep the various elements in perspective.
Excel objects include the following:
- Excel itself
- An Excel workbook
- A worksheet in a workbook
- A range in a worksheet
- A button on a worksheet
- A ListBox control on a UserForm (a custom dialog box)
- A chart sheet
- A chart on a chart sheet
- A chart series in a chart
Notice the existence of an object hierarchy: The Excel object contains workbook objects, which contain worksheet objects, which contain range objects. This hierarchy is called Excel's object model. Other Microsoft Office products have their own object model. The object model concept proves to be vitally important when developing VBA macros. Even if you don't create macros, you may find it helpful to think in terms of objects.
No comments:
Post a Comment