Learning the Basics of Visual Basic

You can get detailed information about a keyword by selecting the word and pressing F1. In Figure 26-4, for example, if you click anywhere within the keyword Sub and press F1, the Visual Basic Editor presents a Help screen containing an entry for the Sub statement, as shown in Figure 26-5.

You can display detailed Help information about any VBA keyword by clicking in the word and pressing F1.

Figure 26-5. You can display detailed Help information about any VBA keyword by clicking in the word and pressing F1.

Many Help topics for VBA keywords include one or more examples of the keyword as you might use it in working code. You can copy this code, paste it into a module, and edit the resulting text to meet your needs. ...

Get Microsoft® Office Excel® 2007 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.