VBA
Course Fees : Rs 18000   Rs 12000/-

VBA Macro

  • Mon – Fri ( 6 Weeks ) | 08.00 AM - 10.00 AM Time (IST) Rs 18000/- Rs 12000/-

  • Sat – Sun ( 8 Weeks ) | 10.30 AM - 06:30 PM Time (IST) Rs 18000/- Rs 12000/-


VBA Macro Syllabus

  • 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
  • Central System
  • Objects
  • Methods
  • Properties
  • Programming Tools
  • The Menu Bar
  • Using the Project Explorer
  • Excel Constants
  • Variable Constants
  • Objects, Properties and Methods
  • Getting & Setting Properties
  • Calling Methods
  • Passing Arguments
  • Singular Objects & Collections of Objects
  • InputBox Function
  • MsgBox Function
  • Using a Set Statement
  • If Then Janision Structures
  • Logical Operators
  • Select Case Janision Structures
  • Case Else
  • Comparison Operators with Select Case Structure
  • For Loops
  • Do Loops
  • While...Wend Statement
  • Run mode and Design mode
  • Running Code from the development environment
  • Running Code from the host application
  • Changing a Property
  • Dimensioning a variable
  • Using variables in routines
  • Object Variables
  • Designing & Creating Forms
  • Working with Controls
  • Creating Custom Dialog Boxes
  • Userform Properties Methods & Events
  • 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
  • Working with the Ribbon
  • Working with Shortcut Menus
  • Providing Help for Your Applications
  • Developing User Oriented Applications
  • VBA Editing & Debugging
  • Auto Macros
  • Error Handling
  • Connect to MS Access
  • Access Database & Retrieve Data from MS Access
  • Create Table & Query Data Filter DB using Query
  • Update and Modify DB
  • Create Single and Multiple Mapping Tables
  • Filter DB using Query
  • Query data grouping
  • Retrieve Data using Logical Access Query
  • Connect to Outlook using VBA
  • Query to retrieve Mail From, to and CC address
  • Retrieve Mail Subject and Time
  • Retrieve Mail Attachment