Microsoft Excel VBA Level 2
Audience aimed at:
Corporate training only
Our Excel VBA Level 2 course is designed for experienced Excel users who have already begun to create macros and know their way around Excel's Visual Basic Editor.
Excel object model
About classes and objects, Objects and collections, The hierarchy of objects, Properties, methods and events, The Locals Window, The Immediate Window
Sub versus function, User-defined functions, Declaring a function, Calling a function, Private and public scope, Defining arguments, Optional arguments
The Application object
When to use, ScreenUpdating property, DisplayAlerts property, Setting CutCopyMode to false
MsgBox function, InputBox function, Application.
- Study level: Intermediate
- Duration of training: Different durations are available for this course
- Study mode: Short full time | Customised