Here is a sample of what you will find in lesson 8 of the downloadable Tutorial on Excel macros

Lesson 8 on Excel macros (VBA):

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.

We hope you have enjoyed this introduction to lesson 8
for more on this topic and a complete course on Excel macros download the
Tutorial on Excel Macros

Next Lesson: Starting, Triggering a Macro in Excel (The Events)