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
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