Microsoft Office — Visual Basic Applications (VBA) Essentials

• 

  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.