Preloader

Overview


vba certification Training in Delhi

A computer programming language developed by Microsoft which allows the development of user-defined functions and the automation of certain processes and calculations. Visual Basic for Applications allows user a level of customization beyond what is typically available in Microsoft Office products, such as Excel, Word and Power Point. A user types commands into an editing module to create a macro. Macros can allow the user to automatically generate customized reports, charts and perform other data processing functions. Within the finance industry, VBA for Excel is commonly used to develop and maintain complex financial spreadsheet models.


  • Module: Recording Macros and Buttons

  •  Absolute and Relative Recording
  •  Where Macros can be Stored
  •  Assigning Macros to Buttons
  • Module: Selecting Cells

  •  Selecting Cells (Absolute)
  •  Selecting Cells (Relative)
  •  Selecting to The End of a Block
  •  Selecting a Range by Its Corners
  • Module: VB Code Editor

  •  Using Project Explorer
  •  Creating Modules
  •  Basic Subroutines and Comments
  • Module: Messages & Variables

  •  Input Boxes and Message Boxes
  •  Declaring Variables
  •  Option Explicit
  •  Scope of Variables
  •  Constants
  • Module: Visual Basic Objet Model

  •  The Excel Object Model
  •  Objects and Collections
  •  Methods and Properties
  • Module: Loops & Conditions

  •  Simple IF Conditions
  •  Multiple IF and SELECT / CASE
  •  Three Main Types of Loop
  • Module: Looping Over Collections

  •  Object Variables
  •  Looping Over Collections
  • Module: Event Handling

  •  Assigning Macros to Events
  •  Cancelling Events
  • Module: Functions

  •  Declaring Functions
  •  Passing Arguments
  • Module: Debugging & Error Handling

  •  Setting Breakpoints
  •  Stepping Through Macros
  •  ON ERROR Statements
  • Module: Forms

  •  Drawing Forms
  •  Attaching Macros to Controls
  •  Validating Form Input
  •  Links to Word or Access
  •  Working With Files and Folders