Introduction to VBA – Office 2010

This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, basic VBA programming, event handling, control structures, and debugging tools.

Delegates will learn how to

• Record and edit a Macro recorded within Excel/Word
• Use different techniques in order to run any macros available such as keyboard commands, the use of the Quick Access Toolbars or Buttons
• Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures
• Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope
• Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks
• Create an error handling routine in case things go wrong with VBA code

This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, basic VBA programming, e vent handling, control structures, and debugging tools.