Excel 2010: VBA Programming
This course is designed to give experienced Excel 2010 users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
Target Audience: This course targets individuals interested in learning the basics of VBA Programming in Excel 2010.
Table Of Contents:
Unit 1: Visual Basic Editor
Topic A: Visual Basic for Applications
Topic B: Object programming
Topic C: The Object Browser
Unit 2: Programming basics
Topic A: Data basics
Topic B: Scope of variables
Topic C: Scope of procedures
Unit 3: Control structures
Topic A: Decision structures
Topic B: Loop structures
Unit 4: Custom dialog boxes
Topic A: User forms
Topic B: Events
Unit 5: Debugging and error handling
Topic A: Errors
Topic B: Debugging
Topic C: Error handling
Course Online Access Login
Click here to go to the online access login screen.