Excel VBA macros Course

VBA stands for Visual Basic for Applications, and is the programming language which comes with Excel (and for that matter with Word, PowerPoint, Outlook and many other applications).  If you've heard people talk about Excel macros, these are just programs written in Excel VBA.

During This Two-day Course, You'll Learn How To:

• Move around a worksheet and select cells
• Work with input boxes, message boxes and variables
• Understand the building blocks of VBA (objects, collections, methods and properties)
• Test conditions and execute loops
• Iterate over the objects in a collection (which turns out to be a useful thing to do)
• Create and use basic user forms

In fact the course will teach you everything you need to learn to become an accomplished VBA programmer in Excel (although be warned that you won't become an expert overnight - that takes months of practice!). 

Topics Covered On This Course:

•  Recording macros and buttons
•  Selecting cells
•  The VB code editor
•  Messages and variables
•  Visual Basic explained
•  Loops and conditions
•  Looping over collections
•  Event handling
•  Functions
•  Debugging and error handling
•  Forms
•  Referencing other applications