Secrets of the Office Masters: Stuck on a Line of VBA Code?

If you get stuck while writing a line of VBA code and don't quite know where to turn, consider right-clicking the command or parameter that's giving you problems, as shown in the following figure.

Figure 41.9.

You have these options:

  • List Properties/Methods gives you a list of all the properties and methods that can replace the property or method you clicked. Pick this option only if you think you've chosen the wrong command.

    Figure 41.10.

  • List Constants tells you which other predefined ...

Get Special Edition Using Microsoft® Office XP 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.