Visual Basic for Applications

  • Description

    This two-day course is intended for participants who are familiar with Microsoft Excel 2010.

    Course Objectives:

    • Understand key concepts that will be used to build custom solutions
    • Become familiar with basic macro techniques for recording, writing, running, and maintaining macros
    • Understand how Visual Basic for Applications is incorporated, used, and modified
    • Learn how to design and layout a user form and controls to create a customized dialog box
    • Understand how to prepare a workbook containing macros and toolbars for deployment
    • Learn to customize macros with VBA source code to automate data entry tasks and enable source code protection
    • Learn to enhance source code with variables, constants, and logical operators
    • Learn to handle errors that can be generated when working with source code
    • Learn to access external data by using ActiveX Data Objects
    • Learn how to control Excel objects externally

    Details

    • Length: 2 day
    • Prerequisites: n/a
    • Cost: $475 plus HST/participant
    • Dates:
      • TBD
       
Back to Top