Sunday 17 June 2012

Lesson 8: Macros Help and Assistance


There is plenty of help and assistance available within Excel when you develop macros. As you have discovered in the previous lesson the Macro Recorder is a great teacher and assistant. 

In this lesson we investigate the two other sources of assistance within the Visual Basic Editor of Excel: the Help Files and the Object Browser.

Here is how the Object Browser appers when you call it. ALL the VBA words are presented in this tool including useful examples. The search function is powerful.

No comments:

Post a Comment