Duration : 1 Month

Fees : 8500 /-

Creating Record Macros

  • Recording a Macro
  • Running a Macro
  • Running a Macro from the Macros Dialog Box
  • Creating a Short-cut key to run a macro
  • Running a Macro with a Shortcut key
  • Assigning a Macro to a Menu or Toolbar
  • Editing a Macro with Visual Basic

Visual Basic Editor

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

The Project Explorer

  • Using the Project Explorer

Using Constants

  • Excel Constants
  • Variable Constants

Excel Objects

  • Objects, Properties and Methods
  • Getting & Setting Properties
  • Calling Methods
  • Passing Arguments
  • Singular Objects & Collections of Objects

Using Visual Basic Functions

  • InputBox Function
  • MsgBox Function
  • Using a Set Statement

Building Formular Control Structures

  • If Then Structures
  • Logical Operators
  • Select Case Janision Structures
  • Case Else
  • Comparison Operators with Select Case Structure
  • For Loops
  • Do Loops
  • While...Wend Statement

Running Code

  • Run mode and Design mode
  • Running Code from the development environment
  • Running Code from the host application

The Properties Window

  • Changing a Property

Variables

  • Dimensioning a variable
  • Using variables in routines
  • Object Variables

Userforms

  • Designing & Creating Forms
  • Working with Controls
  • Userform Properties Methods & Events

Advanced VBA Programming Techniques

  • Developing Excel Utilities with VBA
  • Error Handling
  • Using In-Built Excel Features in VBA
  • Working with Pivot Tables
  • Working with Charts
  • Understanding Excel's Events
  • Interacting with Other Applications
  • Creating and Using Add-Ins
Enquiry
Please Submit the Register Form
Tit Bits