Custom Search
Provided by: Last Minute Training

MS Excel 2003 VBA Macros

Excel

Last Minute Training
Training Provided by Last Minute Training Participants will be able to accomplish the following:

Understand key concepts that will be used to build custom solutions using Microsoft Excel VBA Macros
Become familiar with basic macro techniques for recording, writing, running, and maintaining a macro
Understand how Visual Basic for Applications is incorporated, used, and modified in Microsoft Excel
Learn how to design and layout a user form and controls to create a customized dialog box to simplify data entry
Understand how to prepare an Excel Workbook containing macros and toolbars, for deployment to other users
and machines
Learn to customize macros with VBA source code to automate data entry tasks and enable source code
protection
Learn to enhance source code with variables, constants, and logical operators
Learn to handle the three types of errors that can be generated when working with source code
Learn to access external data by using ActiveX Data Objects
Learn how to use Excel as an automation server to control Excel objects externally outside of the application
This is primarily ilt training
workshop / seminarThis is a workshop seminar
computer labComputer Lab Work
Contact Last Minute Training for more information
Course Level:advanced
Duration:2 days
Training Presented in:English
MS Excel 2003 VBA Macros Building Solutions
Course Overview
Solution Concepts
Data Entry Concepts
Macro Concepts
Programming Concepts
VBA User Form Basics
Planning User Forms
Designing User Forms



Macro Basics
Planning Macros
Recording Macros
Executing Macros
Maintaining Macros

Deployment Basics
Preparing for Deployment
Code Security
Creating Custom Toolbars
Creating Custom Macro Buttons
Attaching Toolbars
VBA Programming Basics
Understanding Objects Using the Visual Basic Editor
Understanding VBA Code
Executing VBA Code
VBA Help Reference

Customizing Macros
Prompting for User Input
Automating Data Entry
Recording Absolute vs. Relative References
Protecting VBA Source Code
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Advertise With Us
Want to market your microsoft training?
This page was last updated on sb5- 10/06/08 at 15:39:14 - 21:05:06