MS EXCEL VBA

We offering MS Excel VBA Online Training USA quite a lot of features. Our faculty has Real Time experience in IT industry. We offer Best MS Excel VBA Online Training at your comfortable timings from your home with flexible schedules. Student can select regular fast track and weekend MS Excel VBA Classes. Each trainer regularly assessed to candidates given the best quality of MS Excel VBA in Online Training. Demos are conducted by every day and you can choose flexible timings according to your requirement.

We provide free demo on MS Excel VBA Online Training Classes and course materials an in-depth knowledge of MS Excel VBA which focuses on real time scenarios. Recorded sessions are provided after each class. We arrange regular and weekend MS Excel VBA Training for employees and students. Resume build as per corporate standards according to the job description and we will market your resume for top companies. We provide MS Excel VBA Online Training and project support across the World like USA, UK, South Africa, Malaysia, Singapore, Australia and Japan.

MS Excel VBA Online Training Course Content

Introduction

  • What is a Macro
  • Recording a Macro
  • Relative References
  • Running A Macro
  • Running A Macro From The Macros Dialog Box
  • Editing A Macro With Visual Basic

Assigning Macros to Buttons and Objects

  • Assigning a Macro to a Button on a Sheet
  • Assigning a Macro to a Drawn Object on a Sheet
  • Assigning a Macro to a Button on a Toolbar
  • Creating A Short-Cut Key To Run A Macro

Visual Basic Editor

  • Objects
  • Methods
  • Properties
  • Programming Tools
  • The Menu Bar

Editing Macros

  • The Visual Basic Editor
  • The Project Explorer
  • The Code Window
  • Procedures
  • Comments
  • Printing a Visual Basic Module

The Range Object

  • The Cells Property
  • The Range Property
  • Flexible Ranges
  • Range Contents

Workbooks and Sheets

  • Activating a Workbook
  • Activating a Worksheet
  • ThisWorkBook

Running Code

  • Run Mode And Design Mode
  • Running Code From The Development Environment

The Project Explorer

  • Using The Project Explorer

The Properties Window

  • Changing A Property

Using Constants

  • Excel Constants
  • Variable Constants

Objects, Properties and Methods

  • Controlling Objects with their Properties
  • Performing Actions with Methods
  • Performing Multiple Actions on an Object

Excel Objects

  • Objects, Properties And Methods
  • Getting & Setting Properties

Variables

  • Using Variables In Routines

Using Visual Basic Functions

  • Inputbox Function
  • Msgbox Function
  • Using A Set Statement

Building Formulae Control Structures

  • If…Then Decision Structures
  • Logical Operators
  • For…Loops
  • Do Loops

Event Handling

  • Vba Editing & Debugging
  • Auto Macros
  • Error Handling

Controls, Dialogue Boxes and Forms

  • Built-In Dialogue Boxes
  • Predefined Dialogue Boxes
  • Custom Forms
  • Worksheet Forms
  • User-Defined Forms
  • Adding Form Controls
  • Form Control Properties
  • Control and Dialogue Box Events
  • Displaying and Dismissing a User Form
  • Handling Form Controls

Control Structures

  • Conditional Control Structures
  • Looping Control Structures
  • Non-Structured Statements
  • Subprocedures