VBA (Macros)

Microsoft Visual Basic for Applications (VBA, Macros) when utilized with Microsoft Excel can construct incredible automated business tools and Solutions through which the unimaginable can be made conceivable.

You can robotize the dreary undertaking, Create the Global Templates, Analytical Dashboards and some more. We are the Pioneer in giving exceed expectations large scale preparing

Our VBA engineer Program is structured by the business specialists. These abilities satisfy the prerequisites of occupations identified with different exercises in Excel like producing reports, getting ready outlines and diagrams, doing counts.

Presently a days there are enormous prerequisites of VBA experts in the business. This program gives you mechanization movement is likewise frequently alluded as Macro. Along these lines it causes clients to spare their time spent behind running the redundant advances.

Excellent substance to store and process the crude information. Preparing incorporates Industry explicit information just as assignments, contextual investigation, venture.

Syllabus:

• Module 1: Introduction

• What is a Macro

• Relative References

• Running A Macro

• Running A Macro From The Macros Dialog Box

• Editing A Macro With Visual Basic

• Recording a Macro

• Module 2: Assigning Macros To Buttons And Objects

• Creating A Short-Cut Key To Run A Macro

• Assigning a Macro to a Button on a Sheet

• Creating A Short-Cut Key To Run A Macro

• Assigning a Macro to a Button on a Toolbar

• Editing A Macro With Visual Basic

• ActiveX and Form Controls

• Module 3: Editing Macros

• The Visual Basic Editor

• The Code Window

• The Project Explorer

• Procedures

• Printing a Visual Basic Module

• Inserting Comments

• Module 4: Workbooks And Sheets

• Running Code

• Activating a Workbook

• This Workbook Vs Active Workbook

• Run Mode And Design Mode

• Activating a Worksheet

• Module 5: Visual Basic Editor / Excel Object Model

• Methods

• Objects

• Programming Tools

• The Menu Bar

• Object Browser (F2)

• Properties

• Module 6: Building Formulae Control Structures

• Logical Operators

• Do Loops

• For... Loops

• If...Then Decision Structures

• Module 7: Variables

• Data Types in VBA

• Defining Variables

• Using Variables In Routines

• Module 8: The Range Object

• The Range Property

• Flexible Ranges

• Range Contents

• The Cells Property

• Set Range

• Module 9: Arrays

• Dynamic Arrays

• Static Arrays

• Definition of Arrays

• Module 10: The Properties Window

• Changing A Property

• Module 11: The Project Explorer

• Sheets, Workbook, Module, User form

• Using The Project Explorer

• Module 12: Objects Properties And Methods

• Performing Actions with Methods

• Performing Multiple Actions on an Object

• Controlling Objects with their Properties

• Module 13: Excel Objects

• Getting Setting Properties

• Objects Properties And Methods

• Module 14: USING CONSTANTS/VARIABLES

• Variables

• Excel Constants

• Module 15: EVENT HANDLING

• Various Events with Excel Objects

• Auto Macros/Event Driven Macros

• VBA Editing & Debugging

• Various Events with Excel Objects

• Module 16: USING BASIC INPUT & OUTPUT FUNCTIONS

• Msgbox Function

• Inputbox Function

• Module 17: CONTROL STRUCTURES

• Non-Structured Statements

• Sub procedures

• Conditional Control Structures

• Looping Control Structures

• Module 18: CONTROLS, DIALOGUE

• Custom Forms

• User-Defined Forms

• Adding Form Controls

• Built-In Dialogue Boxes

• Handling Form Controls

• Displaying and Dismissing a User Form

• Form Control Properties

• Predefined Dialogue Boxes

• Module 19: Interacting with Other Office Applications Like MSAccess and Outlook

• Understanding of the Queries

• Various Kind of Joins

• Connect to Outlook using VBA

• Connect Excel to Outlook

• Introduction to Customised Functions

• Query to retrieve Mail From, to and CC address

• Connect to MS Access

• Understanding of the Queries

• Module 19: CONTROLS, DIALOGUE

• Custom Forms

• User-Defined Forms

• Adding Form Controls

• Built-In Dialogue Boxes

• Handling Form Controls

• Displaying and Dismissing a User Form

• Form Control Properties

• Predefined Dialogue Boxes