Excel 2016/2013/2010 VBA Programming (2007 Upon Request)
This course covers the basics of Visual Basic for Applications (VBA) programming within Excel. Learn how to edit existing macros in VBA, automate common tasks by creating clickable command buttons and simplify data entry through user forms.
Dates & Times
|Course||Date & Time||Location||Cost|
|Excel 2016/2013/2010 VBA Programming (2007 Upon Request)||March 1 - 8:30 - 4:30||Latham||Register|
Corporate and NYS discounts do not apply for this course.
This course is appropriate for individuals who need a better understanding of how to use Visual Basic within Excel or are looking to automate complex actions within their spreadsheets.
Comprehensive reference manual with participant guide and exercises
Access to participant data files
Follow-up support by email or phone for an unlimited period
Lesson 1: Visual basic editor
- Visual Basic for Applications
- Object Programming
- The Object Browser
Lesson 2: Programming basics
- Scope of variables
- Scope of procedures
Lesson 3: Control structures
- Decision structures
- Loop structures
Lesson 4: Custom dialog boxes
- User forms
Lesson 5: Debugging and error-handling