Silabus Ms Excel 2010 VBA

1.       Introduction

·         Macro Introduction and Recording Macro

·         VBA Introduction and Exploring Visual Basic Editor

·         Variables, Arrays, Constants and Data Types

·         Modules, Functions and Subroutines

·         Decisions and Looping

·         Strings, Built-In Functions and Message Boxes

·         Operators

·         Debugging

·         Errors, Handling Errors and Error Functions

·         Dialogs

·         Common Dialog Control

·         Command Bars and Buttons

2.       Excel Object Models

       ·         Excel Object Model

·         Objects, Properties and Methods

·         Exploring Object Browser

·         Object Hierarchy

·         Recording Macros

·         Excel Object Model – Main Objects

·         Application Object

·         Workbook Object

·         Windows Object

·         Worksheet Object

·         Range Object

·         Using Excel to Do Interaction with Other Office Application

·         Interaction with Microsoft Outlook

·         Driving Excel from Other Office Application