Excel VBATutorial                      Tutorial on Excel macros

 

Excel VBA Macros

Excel Macros Table of Contents

Excel Visual Basic Editor

Excel Macros Vocabulary

Excel Userforms

Excel Consulting

Excel Tutorial on Macros

Email to excel-vba.com

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.

VBA Object Browser


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)

 

Excel Tutorial on Macros

Excel VBA Macros

Excel Macros Table of Contents

Excel Visual Basic Editor

Excel Macros Vocabulary

Excel Userforms

Excel Consulting