Microsoft Excel VBA - Foundation/Introductory Course
This very popular Microsoft Excel VBA (Visual Basic for Applications) Foundation/Introductory course is a two day course aimed at advanced Excel users. Students attending this course should have already completed the Excel Intermediate and Advanced courses or alternatively have a very good working knowledge of Excel.
This two day Excel VBA course demystifies the Excel VBA language. The course starts from recording macros from the Excel worksheet and then goes onto show how to write code in the VBA window. This course is a must for any advanced Excel user who records macros on a regular basis.
What is a Macro
Assigning Macros to Buttons and Objects
The Range Object
Objects Properties & Methods
Variables and Constants
Controls & User forms
Menus & Toolbars
Testing & Debugging
Event Triggered procedures