>
Home About CE Services Job Searching Course Searching News Contact Us Sitemap

Information Technology

Update Time:7/9/2012  772 views
Course name:Excel Macros-VBA
Course Code:CET00067
Nature and target:

This program has been specially designed for advanced user who wants to make use of the more powerful features of Excel made available by VBA. This course explores VBA language and delegates will be encouraged to write programs to ensure that future editing, amending and updating can be carried out with the minimum of effort.

Object:Existing Excel power users who wish to utilize the VBA to develop more sophisticated applications
Number:Max 12 persons(class)
The language of instruction:Chinese / English
Teaching methods:
Hours:15 hrs
Teaching supervisor:
Class Date:
Venue:
Tuition:
Content:

l  Introduction to Macros

l  Editing Macros

l  The Range Object

l  Workbooks and Sheets

l  Objects, Properties and Methods

l  Variables and Constants 

l  Control Structures

l  Controls, Dialogue Boxes and Forms

l  Storing Information

l  Toolbars and Display

l  Debugging and Error Trapping

l  Worksheet and Workbook Events 

l  Function Procedures

l  Add-in Applications

l  Appendix - Naming Conventions


TOP