How much knowledge of objects is necessary

There are many objects available in Excel/VBA with all sorts of properties and methods. There are almost 200 objects in the Excel object model alone, and about 5000 properties and methods associated with these objects. Clearly, the reader could not be expected to become familiar with all of these. However, knowledge of the familiar objects like Application, Workbook,

Worksheet, Range and Chart are essential. Regarding the remaining objects in the libraries, it should be noted that experienced programmers are often faced with huge amounts of technical information about object libraries, and so on. They learn to develop ways of exploring the broad range of what is available, to have some idea of what may be useful in the future, and to know how to get the details when or if the need arises.

0 0

Post a comment