Corporate Training By Zack Academy - Excel 2007/2010 - VBA Programming

Why Should You Take This Excel 2007/2010 - VBA Programming Course?

This Excel 2007/2010 - VBA Programming course is designed to give experienced Excel 2007/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.

This Excel 2007/2010: VBA Programming course is task-based and focuses on real-world scenarios and challenges students face in their day to day environments. It will provide all of the training that a person will need to understand and use the programas well as offering an advantage in many fields of employment in today’s advanced technological age. 

The Following Topics Will Be Covered:

1. Visual Basic Editor: 

• Visual Basic for Applications
• Object programming
• The Object Browser

2. Programming Basics: 

• Data basics
• Scope of variables
• Scope of procedures 

3. Control Structures:

• Decision structures
• Loop structures

4. Custom Dialog Boxes:

• User forms
• Events

5. Debugging and Error Handling:

• Errors
• Debugging
• Error handling

Syllabus

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