Tailored Courses for IT and Business Professionals
|
|
Excel VBA Macros Guided Tour
Objectives
This course is designed for experienced spreadsheet users, who may have some knowledge of Macros but no programming experience. The aim of the course is to provide an introductory insight in vba programming in Excel 2003. This includes utilising the Macro Recorder, writing simple procedures and functions, and manipulating the most useful excel objects.
Duration
One Day.
Prerequisites
Thorough knowledge and understanding of Microsoft Excel.
Suggested Next courses
Topics Covered
- Introduction
- Demonstrations of powerful and useful macros
- Illustration of the value of excel macros
- Demonstration of where we are headed by the end of the day
- Using the VBA Recorder
- Recording Macros
- Watching the Recorder Record
- Taking advantage of the recorder to save time
- Using the Recorder to teach you vba
- 9 Ways to Assign and Run Your Macros
- The Macro Run Box
- Shortcut Keys, Menus & Toolbars
- Graphics and Sheet Buttons
- Worksheet Events
- Worksheet cell functions
- Examples of Useful Macros
- Writing Worksheet-cell functions
- Beyond Recording Macros - Editing and Writing Code
- Working with Worksheets and Ranges
- The Range Object
- User Interaction - Msgbox and 2 types of Inputbox
- Common Tasks
- Introduction to the Object Model
- Introduction to Variables and Language Structures
- Programming in the VBA environment
- Features of the envionment
- Modules, Worksheets, Dialogs and Charts
- The VBA Toolbar
- The Help Reference
- Runtime, Designtime and Breaktime
- Understanding Code
- Making Code Clear: Comments and Indentation
- The Immediate Window
- Executing Statements in Break Mode
- Assigning Values
- Printing Values to it, from code or self-referentially
- Debugging
- Debug Code Window
- Break Points and Watch Points
- Stepping Through Code