• Classroom Training   • Online Training   • Corporate Training  • Live Projects & Guidance 

VBA Programming

Courses Information

VBA stands for Visual Basic Application. Learn VBA to extend your excel application and automate your regular task.

In this practical course, you will start from the very beginning, with basic arithmetic and variables, and learn how to autumate your task along the way, you’ll learn about VBA Macros and control flow.

Curriculum
Module 1 - Introduction To VBA
  • Introduction to Excel
  • Introduction to Programming
  • VBA Syntax And Grammar
  • Introduction to Cloud Compu
  • Quick Review of Macros
  • Working with Macros
  • How to use Visual Basic Editor
Module 2 – Understanding VBA Editor
  • The Visual Basic Editor
  • Parts of the VBA Editor
  • About VBA Forms, Sub Procedures & Modules
  • Creating Forms
  • Using Controls and their Properties
  • Running VBA Forms in Excel
Module 3 - VBA Syntax And Grammar
  • Objects – The Grammar
  • Using Properties and Methods
  • Understanding Parameters
  • The Object Browser
  • Understanding object hierarchy
  • Editing Specific Cells
Module 4- Storing Data In Variables
  • How and when to declare variables
  • Selecting data types
  • Fixed and dynamic arrays
  • Constants
Module 5 – Control Structure And Program Flow
  • IF (Else If, Else)
  • Select Case()
  • For Next Loop
  • For Each Loop()
  • Do Until Loop and Do While Loop
  • With, End With
  • Nesting Code
Module 6 – Building Procedure
  • Creating Sub and Function procedures
  • Calling procedures
  • Passing arguments to procedures
Module 7 – Building Intuitive Interface
  • Communicating with the user through the message box
  • Gathering user information with the input box
Module 8 – Variables , Arrays And Constant
  • Using the Immediate Window
  • Using Variables
  • Displaying data and obtaining data from the user
  • Constants
Module 9 – Creating Customized Dialogs with User Forms
  • Command buttons
  • List and Combo boxes
  • Labels
  • Option buttons
  • Check boxes
  • Text boxes
  • Frames
Module 10 – Objects And Collections
  • Workbook and Worksheet Object
  • Range Object and Cell Properties
  • Methods and Properties
Module 11- Fonts And Background
  • Using Font Property in cells
  • Using Various Background Properties in Excel VBA
Module 12 – String Handlings
  • What are Strings
  • Using Left, Right, Mid and Len Functions in VBA
  • Comparing two string using functions
Module 13 – Date / Time and Math Functions
  • Using in-built Date/Time functions of VBA
  • Using in-built Math functions of VBA
Module 14 – Functions
  • Using Excel Worksheet Functions in VBA
  • User-Defined Functions
  • Adding Help to User Defined Functions
Module 15 – Error Handling
  • Run Time Error
  • GoTo line
  • Resume Next
Module 16 – Working With Excel Shortcuts
Module 17 – Implementing VBA in Some Application

Trending Courses