MICROSOFT
EXCEL VBA
This 1 day course has
been specially designed for advanced user who wants to make use of the more
powerful facilities of MS Excel made available by VBA. The course explores VBA
language and delegates will be encouraged to write code to ensure that future
editing, amending and updating can be carried out.
|
Introduction ·
Recording & Running a Macro ·
Relative verus Absolote Code References Assigning Macros to Buttons and Objects ·
Assigning a Macro to a Button or a Drawn
Object on a Sheet ·
Assigning a Macro to a Button ·
Button Image Editor ·
Changing a Button’s Screen Tip Editing Macros · Visual Basic
Editor · Project
Explorer · Procedures;
Inserting Comments · Printing a
Visual Basic Module The Range Object ·
Cells & Range Method; Flexible Ranges ·
Virtual Worksheets; Range Contents Workbooks and Sheets ·
Activating a Workbook / Worksheet Objects, Properties & Methods ·
Controlling Objects with their Properties ·
Performing Actions with Methods ·
Performing Multiple Actions on an Object Variables and Constants Variables, Data Types & Constants |
Control Structures ·
Conditional & Looping Control Structures ·
Passing data between Procedures Controls Dialogue Boxes and Forms ·
Built-In & Predefined Dialogue Boxes ·
Custom, Worksheet & User Defined Forms ·
Adding Form Controls ·
Form Control
Properties ·
Control & Dialogue Box Events ·
Displaying & Dismissing a User Form Storing Information · Using InputBox
/ Using MsgBox / Using Variables Debugging & Error trapping ·
Errors, Break Mode ·
Stepping & Error Handling Worksheet & Workbook Events · Worksheet
Object Events · Workbook Object
Events Function
Procedures · Creating User
Defined Functions Appendix A - Naming Conventions · User Form
Controls · Memory
Variables · ANSII Codes/ MsgBox
settings |
|
© 2012 e-ireland.ie |