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
Next Lesson: Starting, Triggering a Macro in Excel (The Events)