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.