Excel VBA

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs.

VBA stands for Visual Basic for Applications an event driven programming language from Microsoft that is now predominantly used with Microsoft office applications such as MS-Excel, MS-Word and MS-Access.

At the end of the training, participants will be able to:

Pre-requisite

The delegates must have a good knowledge of Excel.

Duarion

5  days

Course Outline

  • 1.Visual Basic for Applications
  • 2.Object Programming
  • Event Procedures and Macros
    • 1.Event Procedures
    • 2.Macros
  • Using Help
    • 1.Getting Help in the Object Browser
  •         2.Using the Visual Basic Editor in Excel
  •          3.Saving and Running a Procedure
  • Data Basics
  • Scope of Variables
    • Reserving a Procedure-level Variable
  • Naming Variables
    • Selecting the Appropriate Data Type and Name for a Variable
  • Using Variables to Accept User Input
    • Reserving a Procedure-level String Variable
    • The InputBox Function
    • Concatenating Strings
  • Decision Structures
    • Using the If Then Else Statement
    • Nesting If Then Else Statements
  • Using the Selection Structure in Excel
  • Coding the Calculator Procedure
  • The Select Case statement
    • The Select Case Statement
  • User Forms
  • Adding a Form
    • The Toolbox
    • Sizing, Moving, Deleting, and Restoring a Control
  • Using the Custom Dialog Boxes in Excel
    • Adding a Form
    • Control Properties
  • The Update Inventory Dialog Box
  • Errors
  • Automation and Error Trapping
    • Using the GetObject Function
    • Intercepting and Handling Run-time Errors
    • Preventing Multiple Instances of an Application
  • Using Automation and Error Trapping in Excel
    • Modifying the OpenMemo Procedure

Reviews