Call Now  892 015 0908

Visual Basic Training Course

VBA

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.

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