Microsoft® Excel VBA Level 3: Branching and Looping will explore the programming capabilities of conditional branch constructs as well as repetitive looping structures. The builds will be cumulative, beginning with the core basics and expanding to include interactive message boxes to control program flow. In addition, basic error-trapping techniques will be featured.
Objective: Upon completion of this course the user will coordinate constructive code blocks that will run coherent loops controlled by conditional statements. They will also use the IF…Then…Else construct to control flow processes featuring conditional branches. Additionally, global methods for trapping program errors will be used.
- Program Looping
- Creating an exit condition
- Using the Do Until…Loop construct
- Quitting a faulty loop
- Controlling Program Flow
- Writing an IF…Then…Else statement
- Adding additional conditional branches
- The ElseIf statement
- Using interactive message boxes
- Error Trapping
- The On Error statement
- Creating an error subroutine
IMPORTANT INFORMATION ABOUT PARTICIPATION: As part of our sponsorship with NASBA, we have agreed to provide at least three (3) instances of engagement per CPE hour (50 minutes). These may come in the form of open-ended questions, hand-raising, polling, and other techniques. You MUST answer or respond to all three opportunities to engage in order to receive credit for that CPE hour. Knowledge Source Inc. retains these responses after all CPE classes for audit purposes.
Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.