Enroll Now & Get Weekend FLAT 10% Offer On All Courses - Use The Coupon Code : GB10

VBA Training

In our daily working life cycle we have many jobs which has to be done manually. Whoever has to do a repeated jobs in their daily routine will have a wish what if our work could be automated? What if system itself do our job and we can just have an eye on it?
  • Yes using the visual basic application the above wish can be made true.
  • Just go through our below course content and understand what magic you can do using this powerful platform.
View More
1425 Ratings
1625 Learners
30 Hours
25 Hours
App Programming & Scripting
365 Days
24 / 7 Support
Intermediate
Online Classroom
Attend our Instructor Led Online Virtual Classroom
USD 224 Enroll now
One to One Training
Get 1-to-1 Live Instructor Led Online Training in flexible timings
USD 299 Enroll now

About Course

This course is about VBA. Which means controlling the whole computer system using the visual basic objects. So that each person who ever does the repeated jobs manually he can make his task to perform automatically.

This course is taught hands-on, you learn by doing.

At end of this VBA training by GangBoard you will be able to,

  • Write VBA program on your own.
  • Understand and modify the existing VBA code on your own.
  • Will get a knowledge to access other applications objects using VBA objects (Ex: All MS-Office suite, third-party tools)
  • Will get a knowledge to access data from any databases (Ex: SQL, Access, Oracle, Etc…)
  • Will get a knowledge to access web-based objects.

VBA is for the one who has a basic knowledge on programming concepts.

  • Fresh Graduates (who has the computer background in their education)
  • College / School Students (who has the computer background in their education)
  • Job Seekers
  • Who wants to automate his daily/weekly/monthly activities.

Prerequisite: Knowledge in computers and understanding about software languages.

VBA is the very powerful tool which comes out with very less cost to purchase. And it will be available until MS-Office suite is available in this world. So which ever company uses the MS-Office suits, all those company will require a VBA developer to automate their work using those applications.

We have defined 30hrs to complete this course for an intermediate person. If you opt for weekend classes both Saturday and Sunday you will be having approximately 2 hours 30 mins in scheduled time of the batch you chose. If you opt of weekdays classes all Monday to Friday you need to spend at-least 90mins.

VBA Syllabus

Introduction of VBA

  • What is VBA?
  • The history of VBA
  • Why choose VBA?
  • VBA Summary

First Steps

  • What is a Macro?
  • How to Enable the Macro?
  • How to Start?
  • How to debug?
  • How to end?

Available Data Types

  • Variables
  • Strings
  • String functions
  • Integers
  • Floating points
  • Constants
  • Private and public
  • Variants
  • Arrays
  • Array functions
  • Booleans
  • NULL and empty
  • Casting

Control Structures: Logical Expressions

  • If statements
  • Else and elseif statements
  • Logical operators
  • Switch statements

Control Structures: Loops

  • While loops
  • For loops
  • Foreach loops
  • Continue
  • Break
  • Understanding array pointers

Sub-Procedure and Functions

  • Subroutine
  • Passing value to sub- procedure
  • Message box
  • VBA Inbuilt functions
  • Workbook and worksheet functions
  • Keywords

Debugging

  • Common problems
  • Warnings and errors
  • Debugging and troubleshooting

Handling Text files, Pictures and charts

  • Open, Edit and close text files.
  • User form controls & ActiveX controls
  • Excel ribbon controls using vba
  • Get image in user form
  • Image box from vba.
  • Handle charts in multiple sheets.
  • Event Handling

User forms

  • Check box
  • Option button
  • List box
  • Form properties
  • Labels
  • Boolean

Database Connectivity

  • ADO & DAO Objects and programming model
  • Connect to a database
  • SQL properties and objects
  • ADO and SQL from VBA
  • References for database connectivity
  • Examples for connections
  • Record set and Records
  • Update, Modify and Delete records

Introduction to Object-Oriented Programming (OOP)

  • Introducing the concept and basics of OOP
  • Defining classes
  • Defining class methods
  • Instantiating a class
  • Referencing an instance
  • Defining class properties

Working with Files and Directories

  • File system basics
  • Understanding file permissions
  • Setting file permissions
  • Accessing files
  • Writing to files
  • Deleting files
  • Reading files
  • Examining file details
  • Working with directories
  • Viewing directory content

mail Automation

  • Outlook Objects
  • Create and send and automated Email
  • Access outlook ribbon controls
  • Send mails using contacts from excel

Upcoming Batches

Start Date End Date Time (EST) ( UTC -5) Day
03 Mar 2017 02 Apr 2017 (09:00 PM - 12:30 AM) Fri,Sat
04 Mar 2017 02 Apr 2017 (08:30 AM - 12:00 PM) Sat,Sun
04 Mar 2017 02 Apr 2017 (03:30 AM - 07:00 AM) Sat,Sun
07 Mar 2017 24 Mar 2017 (09:00 AM - 11:30 AM) Tue-Sat
06 Mar 2017 23 Mar 2017 (08:30 PM - 11:30 PM) Mon-Fri
11 Mar 2017 09 Apr 2017 (03:30 AM - 07:00 AM) Sat,Sun
10 Mar 2017 09 Apr 2017 (09:00 PM - 12:30 AM) Fri,Sat
11 Mar 2017 09 Apr 2017 (08:30 AM - 12:00 PM) Sat,Sun
13 Mar 2017 30 Mar 2017 (09:30 PM - 11:30 PM) Mon-Fri
14 Mar 2017 31 Mar 2017 (09:30 AM - 11:30 AM) Tue-Sat
17 Mar 2017 16 Apr 2017 (09:30 PM - 12:00 AM) Fri,Sat
18 Mar 2017 16 Apr 2017 (09:30 AM - 12:00 PM) Sat,Sun
18 Mar 2017 16 Apr 2017 (04:30 AM - 07:00 AM) Sat,Sun
20 Mar 2017 06 Apr 2017 (09:30 PM - 11:30 PM) Mon-Fri
21 Mar 2017 07 Apr 2017 (09:30 AM - 11:30 AM) Tue-Sat

VBA Certification

At end of our course, you will be assigned to work a real-time project. Once you completed assigned project with expected results we (Experts Team from GangBoard) will verify and issue VBA Developer Certificate. If you are not able to deliver expected results in project we will support you by clarifying doubts and help you to re-attempt the project.

VBA Training Reviews

FAQ

Detailed installation of required software will be displayed in your LMS. Our support team will help you to setup software if you need assistance. Hardware requirements need to be fulfilled by participants.

No worries. It might happen. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. And if required you can even attend that topic if any other live batches.

Top-notch professionals in that field who understands how to convey things in technical as well as subject matter experts.

We offer this course in “Live Instructor-Led Online Training” mode. Through this way you won’t mess anything in your real-life schedule. You will be shared with live meeting access while your session starts.

No. VBA itself is low level general purpose scripting language. It is not mandatory to be a developer before for learning this VBA training.

Basically >2GB RAM will be fine for installing either LAMP stack or WAMP stack. Even if you have MAC there is MAMP stack available for free.

You can get a sample class recording to ensure you are in right place. We ensure you will be getting complete worth of your money by assigning a best instructor in that technology.

We are absolutely loved to talk in-person about group training (or) corporate training. So, please get in touch with our team through “Quick Enquiry”, “Live Chat” or “Request Call-back” channels.

Payments can be made using any of the following options and a receipt of the same will be issued to you automatically via email.

  1. Visa Debit Card / Credit Card
  2. American Express
  3. Master Card, Or
  4. PayPal

We are providing VBA online training, One-to-One training with the help of experts. Our learners and trainers are frequently coming from different countries like USA, India, UK, Australia, New Zealand, Canada and UAE. To specify in cities London, Bangalore, California, New York, Pune, Mumbai, Chennai, New Delhi, San Francisco, New Jersey, Texas, Florida, Kolkata, Gurgaon, Berlin and Hyderabad among many.

You can reach us through +91-9791273737 / +91-9791237373. Or you can share your quires through enq@gangboard.com. Estimated turnaround time will be 24 hours for emails.

+91 - 755 008 0081
+91 - 755 008 0082

Drop us a Query

Please ensure all fields are valid.

+91

Drop us a Query

We are looking into your query.
Our consultants will get in touch with you soon.
GangBoard 5 Star Rating: Recommended 5 out of 5 based on 1425 ratings.