Excel Visual Basic For Applications

This course aims to cover in detail the Visual Basic for Applications programming language. You will learn how to program in VBA in order to customise your work environment in Excel. You will learn to understand programming terminology such as modules, procedures, variables and constants. You will learn form design, control structures and how to debug and test your VBA application before using it in the work environment.

Upon completing this course, you will have learned how to:

• Understanding Templates and Macros
• Looking at the Visual Basic Editor
• Recording a macro
• Designing Forms
• Learning to write code
• Understanding Procedures
• Using Variables and constants
• Understanding Properties, Methods, Events and Objects
• Understanding the Range Object (in Excel)
• Control structures
• Debugging and Error-trapping