Tuesday 24 July 2012

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

No comments:

Post a Comment