Training Course Specification

Course: Microsoft Excel MACROS
Duration: 1 - Day - £125+VAT

COURSE OBJECTIVES: This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to write macros using VB code and assign macros to screen items.

WHO SHOULD ATTEND: 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.

EXPERIENCE NEEDED: Delegates 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.

COURSE CONTENTS: 
Introduction and the Macro Recorder
Introduction
Demonstration
Recording a macro
Recording a macro with absolute references
The personal macro workbook
Assigning shortcut keys
Deleting macros
Recording a macro with relative references
Exercises
Objects and Dialog Boxes
Introduction to objects
The object browser
Using the object browser and searching it
Built-in dialog boxes
User defined dialog boxes (message boxes and input boxes)
Exercises
Creating and Editing Macros With VBA Macro Functions
Macro storage concepts
The VBA program (the VB editor)
The program components
Storing and handling macros (modules)
Introduction to editing code
Copying and pasting procedures
Linking procedures together
Create and use a user-defined function
Auto-executable macros
Introduction to Controls
Worksheet controls
User forms
Exercises
IF…THEN…ELSE (Conditional Control Structure)
SELECT CASE (Branching)
The DO…LOOP control structure
The FOR…NEXT control structure
Exercise 1: Case Changer Macros
Exercise 2: Change Object Properties
Exercise 3: Copy Macros
Exercise 4: Custom Menus
Exercise 5: Input Boxes
Exercise 6: Linking Macros
Exercise 7: Message Boxes (MsgBox)
Exercise 8: User Defined Functions

« Back