Using VBAs Help system

The VBA Help system describes every object, property, and method available to you. This is an excellent resource for finding out about VBA and is more comprehensive than any book on the market.

If you're working in a VBA module and want information about a particular object, method, or property, move the cursor to the word you're interested in and press F1. In a few seconds you see the appropriate help topic, complete with cross-references and perhaps even an example or two.

Figure 4-2 shows a screen from the online Help system — in this case, for a Worksheet object.

^ Click Properties to get a complete list of this object's properties. ^ Click Methods to get a listing of its methods. ^ Click Events to get a listing of the events it responds to.

Figure 4-2:

An example from VBA's Help system.

Figure 4-2:

An example from VBA's Help system.

0 0

Post a comment