Getting Help in Excel

To get detailed help on VBA, in the Visual Basic Editor (accessible from the Developer Ribbon):

• Press 'F2' to open the Object Browser. The Object Browser shows you a list of all the classes, and allows you to search by the name of an entity (be it a function, method, property or class). When an enitity is highlighted, press ? for a detailed reference on how to use it. Use the Object Browser to avoid too much guesswork. In particular, if you want to know what you can do with an object, just browse its class (try it, for instance, with the ubiquitous 'Range' class) and get help on interesting sounding methods and properties.
• Press 'F1' when selecting an entity in the editor to get its detailed reference.