18 Working with VBA

18.1 Getting help

There are several ways you can get help while working in the VBA editor. You can:

1  click Microsoft Visual Basic for Applications Help under the Help menu, or …

2  press the F1 key, or …

3  click on the toolbar and select the Help button.

This will open a help window as shown in figure 18.1.

images

Figure 18.1   The Excel Help dialogue.

In this window you can type in the name of an object, method, property etc. in the text box in the upper left corner and then click the Search button.

The fastest method though, is to click in a word and press F1. You will then get help on how it’s used.

Intellisense

As you are ...

Get Financial Modelling and Asset Valuation with Excel 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.