Visual Basic for Applications (VBA) Level 1: Macro Programming Student Courseware

This student workbook is to be used as courseware for an instructor led 10 to 12 hour course. The workbook introduces macro programming using Excel Visual Basic for Applications (VBA) to automate and customize operations in Word, Excel, and Access. The author introduces more programming techniques thru many exercises. The Visual Basic editor will be used to create user interfaces, write VBA code, execute and debug programs. Content includes good programming practices, object naming conventions, flow charting, writing VBA code procedures, procedural scope, dimensioning variables, dialog boxes, looping, decision-making with If Functions, running macros automatically, recording a macro and understanding the necessity to document program code. I have developed and used this courseware for over 15 years to teach Visual Basic for Applications (VBA) to over 500 students. It is intended to be used as a resource tool for the instructor or as a standalone workbook for the student. This is the first of two Levels.