VBA for Microsoft Excel
VBA for Microsoft Excel
Course Description
This course is for people who wish to improve their skills by using Visual Basic for Applications (VBA) to increase productivity by automation in Excel.
Performance Based Objectives
- Record macros using the recorder and create an application using the recorder
- Create user-defined functions and work with the VBA editor
- Understand VBA concepts and features, create procedures and sub routines
- Work with variables and Excel objects
- Use standard programming techniques and concepts
- Create and program custom forms
Course prerequisites
Participants will need to have attended the Microsoft Excel Advanced course or a working knowledge of the topics covered including recording Macros in Excel.
Course Features
- Students
- Max Students10
- Duration2 day
- Skill leveladvanced
- LanguageEnglish
- Re-take courseN/A
-
Recorded Macros
-
Understand Excel VBA
-
Using the VBA editor
-
Working with Excel objects
-
Working with code
-
User input and variables
-
Programming techniques
-
User-defined functions
-
Creating user forms
-
Coding a user form
-
Event procedures
-
Appendix