|
|
|
Course ID: 5375
| Course Duration: 2 Days
|
|
Course Dates:
|
| |
|
| |
VBA for Excel Training Class
Course ID: 5375
|
|
| |
|
|
| |
|
|
| |
VBA for Excel Training Seminar
Overview:
Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Introduction
Applications Interfaces
Options
Setup
|
|
Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming
|
Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects
|
Lesson 4: Visual Basic Editor
Application Switching
Menus - View, Tools, Help
Windows - Project, Property, Object, Immediate & Module
Code Conventions
Use Immediate Window
Run & Debug
Modules, Subs, Functions & Scope
|
Lesson 5: Interface Boxes
Message Boxes
Input Boxes
Forms - Dialog Boxes
|
|
Lesson 6: Variables
|
Lesson 7: Conditional Routines
Immediate IF Statements
IF-THEN Statements
Case Statements
Loops - FOR/NEXT, DO/WHILE, DO/UNTIL
|
Lesson 8: Introduction to Arrays
|
Lesson 9: Functions in Excel
| |
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
VBA for Excel Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5375
| Course Duration: 2 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
 Gift card when you register today!
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |
|
|
|
|