Visual Basic Training Course
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
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
