Introduction to VBA for Excel

Duration

3 days (groups)

Outcomes

The delegate will be able to:

• Use macros to do complex tasks
• Use dialogue boxes
• Use variables
• Create an IF Statement
• Use arrays

Unit Standards

There are no unit standards set for this course

Prerequisites

Daily use of Microsoft Excel up to advanced level and an understanding of macros.

Course content

• An introduction to Macros in Excel
  • editing/deleting macros from the Personal Macro Workbook
  • Understanding relative and absolute macros
  • Assigning Macros to toolbars, drawing objects or a menu
• Making Macros do complex tasks
• Using variables
  • Declaring variables
• Using Dialogue Boxes
• Userforms vs ‘InputBox’ command
  • Inputbox
  • UserForms
  • Call a Userform with Visual Basic coding
• The If Statement
• The Select Case statement
• The For Next Loop
• Do Loop
• Using arrays
• Working with Worksheets
• Creating User-Defined Functions
• Public functions vs Private functions