ObjectSharp logo
The Microsoft Software Development and Training Experts

Course Info

Guaranteed-to-Run
Instructor-in-Cloud
Duration: 3 days
Price: $897

Upcoming Classes

June 2013

Mon 10 - Wed 12 Register

July 2013

Wed 10 - Fri 12 Register

Call to register

416-649-3691

Learn from the
Pros Who Know

During this course students will have the opportunity to discuss their own projects with an ObjectSharp subject matter expert.

Home > Training > 

Excel 2007: Programming with VBA

Course Outline

Lesson 1 - Getting Started
  1. Introducing Visual Basic for Applications
  2. Displaying the Developer Tab in the Ribbon
  3. Recording a Macro
  4. Saving a Macro
  5. Enabled Workbook
  6. Running a Macro
  7. Editing a Macro in the Visual Basic Editor
  8. Understanding the Development Environment
  9. Using Visual Basic Help
  10. Closing the Visual Basic Editor
  11. Understanding Macro Security
Lesson 2 - Working with Procedures and Functions
  1. Understanding Modules
  2. Creating a Standard Module
  3. Understanding Procedures
  4. Creating a Sub Procedure
  5. Calling Procedures
  6. Using the Immediate Window to Call Procedures
  7. Creating a Function Procedure
  8. Naming Procedures
  9. Working with the Code Editor
Lesson 3 - Understanding Objects
  1. Understanding Objects
  2. Navigating the Excel Object Hierarchy
  3. Understanding Collections
  4. Using the Object Browser
  5. Working with Properties
  6. Using the With Statement
  7. Working with Methods
  8. Creating an Event Procedure
Lesson 4 - Using Expressions, Variables, and Intrinsic Functions
  1. Understanding Expressions and Statements
  2. Declaring Variables
  3. Understanding Data Types
  4. Working with Variable Scope
  5. Using Intrinsic Functions
  6. Understanding Constants
  7. Using Intrinsic Constants
  8. Using Message Boxes
  9. Using Input Boxes
  10. Declaring and Using Object Variables
Lesson 5 - Controlling Program Execution
  1. Understanding Control
  2. of
  3. Flow Structures
  4. Working with Boolean Expressions
  5. Using the If...End If Decision Structures
  6. Using the Select Case...End Select Structure
  7. Using the Do...Loop Structure
  8. Using the For...To...Next Structure
  9. Using the For Each...Next Structure
  10. Guidelines for use of Control
  11. of
  12. Flow Structures
Lesson 6 - Working with Forms and Controls
  1. Understanding UserForms
  2. Using the Toolbox
  3. Working with UserForm Properties, Events, and Methods
  4. Understanding Controls
  5. Setting Control Properties in the Properties Window
  6. Working with the Label Control
  7. Working with the Text Box Control
  8. Working with the Command Button Control
  9. Working with the Combo Box Control
  10. Working with the Frame Control
  11. Working with Option Button Controls
  12. Working with Control Appearance
  13. Setting the Tab Order
  14. Populating a Control
  15. Adding Code to Controls
  16. Launching a Form in Code
Lesson 7 - Working with the PivotTable Object
  1. Understanding PivotTables
  2. Creating a PivotTable Using Worksheet Data
  3. Working with the PivotTable Objects
  4. Working with the PivotFields Collection
  5. Assigning a Macro to the Quick Access Toolbar
Lesson 8 - Debugging Code
  1. Understanding Errors
  2. Using Debugging Tools
  3. Setting Breakpoints
  4. Stepping through Code
  5. Using Break Mode during Run mode
  6. Determining the Value of Expressions
Lesson 9 - Handling Errors
  1. Understanding Error Handling
  2. Understanding VBA's Error Trapping Options
  3. Trapping Errors with the On Error Statement
  4. Understanding the Err Object
  5. Writing an Error
  6. Handling Routine
  7. Working with Inline Error Handling
show more>>

Guaranteed-to-Run

Our Live Instructor-in-the-Cloud classes are Guaranteed-to-Run. And you can count on it. They’re Online Live (OLL), and that means you never have to worry about cancellations caused by low enrolment or other problems. All our Guaranteed-to-Run classes run on their scheduled dates. No exceptions. No excuses. We guarantee it!

show more>>

Our outstanding ObjectSharp instructors are known throughout the IT community for their real-world business experience. We’ve teamed them up with the best IT trainers from across North America. Together, they allow us to offer a huge array of IT training classes to our clients.

From Microsoft to Oracle, from Adobe to Cisco, we’re running over 500 Live Instructor-led classes in the next 90 days alone! And almost all of them are Guaranteed-to-Run. One more reason why ObjectSharp is your best choice for IT technical training in Toronto.

Our Training Center

We encourage you to take this Instructor-Led Training: Live Online course at our downtown Toronto Training Center at 40 University Avenue. For TTC riders, we are right on the subway line just south of the St. Andrews station. For GO-Train commuters, we are just steps north of Union Station.

show more>>

In our Training Center every student gets their own powerful Dell workstation with dual monitors. Our classrooms are designed around comfortable ergonomic chairs, generous work surfaces, special air conditioning by classroom and a high-speed fibre connection to the Internet. So it really is a great place to take any of our courses.

Our Training Center

However, we understand that it is not always possible for you to take this Instructor-Led Training: Live Online course at our Center. Therefore, you have the option to take part or all of this course from an offsite location. As long as you have at least DSL-speed Internet connectivity, our Operations Staff can easily connect and join you into this Instructor-Led Training: Live Online class directly from your work, home or other location. Our Site, Your Site or Offsite. Whatever works best for you!

Microsoft Gold Certified Partner Home  |  Consulting  |  Training  |  Company
© 2012 ObjectSharp Corp.416-649-3690