Here is a sample of what you will find in the downloadable Tutorial on Excel macros
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 tip
To organize your discovery of Excel macros, the downloadable Tutorial on Excel Macros is divided in three sections (all 3 sections part of the single download):
Section 1: Excel Macros Programming (Chapters 1 to 10)
Section 2: Excel VBA Vocabulary (Chapters 11 to 23)
Section 3: Forms and Controls in VBA for Exce (Chapters 24 to 33)