You will learn how to:

• Record and edit a Macro
• 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

Schedule

Session 1 - 9hrs
Full Day Session 1

Session 2 - 7hrs
Full Day Session 2