Microsoft Excel VBA Programming Course- Formatech

Information Technologies

hours

language

English

Target Audience

Students should have familiarity with personal computers and the use of the keyboard and mouse. They should have completed introduction, intermediate and advanced courses in Excel or have equivalent practical experience.

01 Unit 1: Visual Basic Editor
+

Topic A: Visual Basic for Applications

Topic B: Object programming

Topic C: The Object Browser

02 Unit 2: Programming basics
+

Topic A: Data basics

Topic B: Scope of variables

Topic C: Scope of procedures

03 Unit 3: Control structures
+

Topic A: Decision structures

Topic B: Loop structures

04 Unit 4: Custom dialog boxes
+

Topic A: User forms

Topic B: Events

05 Unit 5: Debugging and error handling
+

Topic A: Errors

Topic B: Debugging

Topic C: Error handling

minimize course outline