Our introduction to Microsoft Excel VBA training course is for those responsible for very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data.  At the end of the training course you will have covered the fundamentals of VBA (Visual Basic Applications), including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions.
You will have mastered how to control program execution, working with forms and controls, working with the PivotTable object. Finally the course also includes modules on debugging code, handling errors to ensure minimal downtime while building and effecting the program.

Those who complete the Introduction to Microsoft Excel VBA course satisfactorily will receive a certificate at the end of the computer training course.

Read on for further information on the Introduction to Microsoft Excel VBA course. For more information on our computer course trainers, and computer training course content and fees visit this computer training courses information page

Introduction to VBA
• A look at the history of VBA
• importance and relevance to today's solutions and consideration of compatibility issues.

Concepts in VBA
• Getting to grips with Objects and their Properties and Methods
• Understanding Procedures and Modules.
• An introduction to events and event handling
• Treatment of Objects in general.
• An introduction to naming conventions.
• How Properties and Methods are accessed and used.

Variables & Constants
• A general introduction to storage using Variables and Constants.
• When and how to declare, use and name them.

Control Structures
• Determining the flow of a program.
• Writing self-contained, re-usable Procedures.

Controls
• Control types commonly found in Microsoft applications.
• How to create and use them.

Procedures & Functions
• Calling Procedures from other Procedures.
• Passing data between Procedures.
• Using standard Functions.
• Use of Named Arguments.
• An introduction to the creation and use of custom Functions.

Menus & Toolbars
• Using the Menu Editor.
• Creating and customising Toolbars.
• Assigning Procedures.
• Manipulation within Procedures.

Debugging & Error Handling
• Types of errors and how to handle them.
• Investigating problems using the Debug Window.