Book Free Demo !

Excel VBA

Visual Basic for Applications is an implementation of Microsoft’s event-drive programming language, Visual Basic 6.0, built into most desktop Microsoft Office applications.

VBA LOGO
Book Free Demo

Course Content 

  • VBA Introduction
  • Intro of VBA IDE
  • Types of modules and form in VBA
  • Uses of VBA
  • If condition and Case statement in VBA
  • Nested if and else statements
  • Nested if using AND, OR and Not Operator
  • Cells and range in VBA
  • Copy and paste in VBA
  • Paste special in VBA
  • Introduction of loop
  • For loop in VBA
  • Do While and Until loop in VBA
  • Importance of loops in VBA
  • Use cases on Loops
  • Dynamic range and cells
  • Uses of XLUP, XLRIGHT, XLDOWN, XLLEFT in VBA
  • Select method in VBA (Union, except, offset, resize etc)
  • Excel sheet property in VBA (add, delete, move, copy etc)
  • Workbook property in VBA (Open, Kill, Save, Save as etc)
  • Special cells feature using VBA
  • Uses of Excel functions in VBA (Count, Vlookup, Sum, Text Function etc)
  • Uses of VBA Formula
  • Writing Dynamic Formula
  • File scripting Object (FSO) in VBA
  • Working with Files an folders
  • How to create User defined formula
  • Use of ByVal and ByRef in Function
  • For Each loop concepts in VBA
  • Creating UDF using array
  • How to call a Function in Program
  • Difference between procedure and function
  • How to Call a UDF from excel
  • User form controls and events
  • Uses of combo box, text box, labels.
  • Difference between combo box and list box
  • Use of tab page
  • Project work: Design a user form for controlling the tabs.
  • Types of Database Connection
  • Connection with MS-Access
  • Connection with MS-Excel
  • Connection with MS-SQL Server
  • Query (Select/Update/Delete/Add/Insert)
  • Call a stored procedure from VBA
  • Pivot table
  • Charts
  • Shape Object
  • Send a new Email
  • Send Email with attachments
  • Send Email with Snapshots
  • Send Email with HTML mail body
  • Navigate a URL
  • Read data from
  • Internet ExplorerIntroduction of Web Crawling
  • What is Addins
  • Uses of Addins
  • Project work

Explore More

See Whole Course

Flexibility in Planning and Teaching

Theoretical Knowledge

Practical Skills

Individual Work with a Mentor

Final Individual Project

The premier destination for individuals seeking to elevate their professional skills and excel in their careers.

Facebook-f Instagram Twitter Whatsapp

Book Your Live Demo Now !

Book Now !

Copyright © 2023 WebridgeTech Pvt Ltd All rights reserved.

+91-8130121986

info@idacareer.com

Skip to content