|
TCET ~ Microsoft Training ~ Adobe Training ~ Macromedia Training Cancellation Policy
Description:
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
CORE TOPICS
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
|
Pre-Requisites: MS Excel - Level 2
Certificates offered: Certificate of Completion.
Duration Details: 2 Days
9:00 am - 4:00 pm
Facility Location: HBI College
190 Robert Speck Parkway
Mississauga
Ontario
Canada
L4Z 3K3
|
