HOT LINE:

+919019191856

+1 (201) 720-5410 (USA)

My Cart

0

Excel VBA

Training Mode: Class Room / Live Online


Need Help? please call us on +919019191856 or Click Here to send us an Enquiry

QUICK OVERVIEW

Excel VBA Training in Bangalore - Live Online & Classroom

myTectra the Market Leader in Excel VBA Training in Bangalore

myTectra offers Excel VBA training in Bangalore using Class Room. myTectra offers Live Online Excel VBA Training Globally.

 

Introduction

Event-oriented programming
How to add Developer Tab into your Excel instance
Code Window, Properties Window, Project Explorer, Tool Bars

Variables And Constants

Objects -Properties and Methods
Variables
Data Types
Difference between variables and Objects

Option Explicit

Explicit variable declarations using the Option Explicit statement
Implicit variable declarations

Variables And Scoping

Scope Of Variables in Sheets, User Forms, Modules

VBA Functions

Built-in Functions
Sending Messages To The User, Lcase, Ucase, Len, Trim, Format etc

Conditional Branching

The If Statement, Using If For Single Conditions
Using If For Multiple Conditions, If Then Else End If, If Then Else ElseIfEnd If, The Select
Case Statement

User Defined Procedures And Functions

Creating and calling User-Defined Procedures and Functions
Modifying Procedures and Functions

Iterations (Loops)

Iterations -FOR Loops
While ...Do...Until... Loop Statements for looping With Known Or Specified number of iterations
Endless Loop for Unknown Iterations by using Exit Do statement

Error Handling

Error Handling and how it differs from Validation
Creating Error Handlers In Event Procedures
Technique to get user input by using The InputBox
Using The Resume statement, Resume Next statement
Using The Err Object to get more information about errors
User Defined Errors by using Raise method

Validations

Validation
Validation using Text Box Events
Validation on Save using Button

List Boxes

Adding List Boxes to A Form
Simple List Boxes and Multiple List Boxes

Check Boxes, Option Buttons, Frame

Adding Controls such as Text Boxes, Labels, Combo Box, Option Buttons, Check Boxes, Coding on various events
Adding Different Sets of Option Buttons to a Form without mismatch of options by using Frame Control
Important properties, methods and events of the above controls

Debugging

Run Time, Design Time, and Break Mode
Debugging Techniques such as stepping into, stepping over, and stepping out Run
Run To Cursor
Set Next Statement
Quick Watch and Three types of watches

File System Objects

File System Objects (FSO/Microsoft Scripting Runtime Object) Exploring files and folders,interactionof excel file with withText files as well as excel files using FSO method

Multiple Forms, Form Events

Programming User Forms by Handling Form Events
Handling multiple forms

Workbooks Properties And Methods

Workbook Methods And Properties, Worksheet Methods And Properties

Range Object Properties And Methods

Using Range Objects
Range Methods And Properties
Manipulating worksheets and data in the worksheets within same workbook
Manipulating worksheets and data in the worksheets in different workbooks

Collections

Collections
User controls, Forms, Workbooks, Worksheets, Folders, Files

Arrays

Simple Arrays, Dynamic Arrays

Formatting Cells, Formulas

FormattingCells, Colors, Font etc

Application Object

Screen updating, DislayAlerts, Dialog box

To Learn Live Online Excel VBA Training Globally and Excel VBA Training in Bangalore using Class Room, ENROLL TODAY at myTectra.


Customer Reviews

3 Item(s)

per page
Nice Institute Review by Smita
Price
Quality
Value
Mytectra Do Support Me well for the Course and Solve my Queries to the Extent and very helpful. Have got practical experience of the course and well versed with the course
myTectra has a good environment and faculty are friendly Review by Naveen Jevoora
Price
Quality
Value
I joined in this institute. The trainers are experienced people and they are guiding well. I am happy with the training given by them. The timings are also very much comfortable
one of the best institute in bangalore Review by Venugopal Avinash Sana
Price
Quality
Value
"I have taken Excel VBA Training from myTectra . I strongly recemend this program to others."

3 Item(s)

per page

Only registered users can write reviews. Please, log in or register

brand
myTectra Stands for Quality Training and provides training using Experienced professionals on the Respective Technologies and who has a good teaching expertise.


WHY DO YOU AWAIT FOR FIXED SCHEDULES ? CHOOSE MYTECTRA LEARN AT YOUR CONVENIENT TIME

myTectra flexible batch schedules enables you to start your class at your convenient date and time.


1. All the enrolled candidates must start the class by any date within 30 days from the date of enrollment.
2. Maximum of 3 Days will be taken by myTectra to schedule the batches from the date of schedule request from the candidate.
3. Individual Focus - Maximum 5 candidates allowed per batches
4. The candidate can request any one of the batch time slot from the below list
Batch Type Time Slab Hours/Day Time Zone Days
Regular Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Friday
Regular Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Friday
Week End 6.30 AM - 9.30 PM Anytime Maximum 3 Hrs IST Saturday,Sunday
Fast Track-Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Fast Track-Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Customized Batch Customized Timing Customized Hrs IST Customized Days

Note : We can schedule your batch anytime on Saturday and Sunday between 6.30 AM 9.30 PM at your convenient time


Do you have any questions ? please call us on +919019191856 or email to [email protected]