 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2000 Macros
Course Aims
This course covers automation and customising of Excel 2000 using macros and screen items (such as buttons and menus). Readers learn how to write macros using VB code and assign macros to screen items. |
Assumed Knowledge
Readers should have a good grounding in Excel (any version) and be familiar with absolute Vs relative cell referencing, functions and formula syntax and sheet linking. Familiarity with the macro recorder would be an advantage. |
Course Audience
Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users' work) in the application using macros. However, those wishing to learn or practice VBA itself should seek another course. |
|
Table of Contents
|
Introduction And The Macro Recorder
|
Recording A Macro With Absolute References
|
|
The Personal Macro Workbook
|
|
Recording A Macro With Relative References
|
|
|
|
Creating And Editing Macros With Vba
|
The VBA Program (The VB Editor)
|
|
Storing And Handling Macros (Modules)
|
|
Introduction To Editing Code
|
|
Copying And Pasting Procedures
|
|
Linking Procedures Together
|
|
Create And Use A User-Defined Function
|
|
|
|
Objects And Dialog Boxes
|
Using The Object Browser And Searching It
|
|
User Defined Dialog Boxes (Message Boxes And Input Boxes)
|
|
|
Introduction To Controls
|
Assigning Macros To Toolbar Buttons (Icons)
|
|
Customising The Excel Screen
|
|
|
|
Appendix A: Selected VBA Procedures
|
If...Then...Else (Conditional Control Structure)
|
|
The Do...Loop Control Structure
|
|
The For...Next Control Structure
|
|
|
|
|
Appendix B: Course Exercises
|
|
|
|
|
