What We Offer

Visual Basic For Application (VBA)

Introduction to VBA

  • What is VBA?
  • What Can you Do with VBA?
  • Recording a Macro
  • Procedure and Functions in VBA

Variables in VBA

  • What is Variables?
  • Using Non-Declared Variables
  • Variables Data Types
  • Using Const Variables

Message Box and Input box function

  • Customizing Msgboxes and Inputbox
  • Reading Cell Values into Messages
  • Various Button Grops in VBa

If and Select Statement

  • Simple if Statements
  • The Elseif Statement
  • Defining select case statements

Looping in VBA

  • Introduction to Loops and Its Types
  • Work with For Next Loop
  • Work with Do While Loop
  • Work with While Wend Loop
  • Work with Do Until Loop
  • Work with collection loop (For Each)

Arrays in VBA

  • Introduction about Arrays
  • Single Dimensional Array Vs Multidimensional Array
  • Statics Array Vs dynamic Array

Dictionary Function In VBA

  • Introduction of Dictionary Function
  • Dictionary Vs Array

Mail Functions - VBA

  • Using Outlook Namespace
  • Send Automated Mail
  • Outlook Configurations (MAPI)
  • Push outlook e-mails in Excel

Web Scraping - VBA

  • Data Extracted from Website to Excel