Excel VBA Intermediate
Course
Inhouse
Description
-
Type
Course
-
Level
Advanced
-
Methodology
Inhouse
-
Duration
2 Days
-
Start date
Different dates available
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.
Facilities
Location
Start date
Start date
About this course
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.
Reviews
Subjects
- Excel
- Basic
- Visual Basic training
- IT
- Basic IT training
- Basic IT
- Property
- Visual Basic
- MS Excel
- Excel on-site training
- Excel in-house training
- Excel training
Course programme
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.
Course Outline
Excel object model
About classes and objects, Objects and collections, The hierarchy of objects, Properties, methods and events, The Locals Window, The Immediate Window
Function procedures
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
Dialogue boxes
MsgBox function, InputBox function, Application.Dialogs
UserForms
Creating a userform, Displaying a userform, Adding Label controls, Adding a TextBox control, The CheckBox control, The OptionBox control, ComboBox and ListBox, SpinButton controls, Adding CommandButtons, Setting control properties
Workbooks and worksheets
The Workbooks collection, The Sheets collections, The Window objects, Workbook events
Ranges and names
Column and Row properties, CurrentRegion property, The Union method, The Intersect method, Using the Name property, Working with named ranges
Pivot tables
Pivot table code overview, Creating a pivot table, PivotField object, PivotItems collection, Modifying a pivot table, Using external data
Charts and drawings
About programming charts, Working with embedded charts, Working with independent charts, Controlling chart formatting, Assigning a range to a chart, Positioning a chart, Making a chart active/inactive, Editing data series, Controlling chart labels, Drawing shapes, Setting shape attributes
Additional information
£900 for one-to-one training
£1,100 for groups of up to 6 people
£1,300 for groups of up to 12 people
Excel VBA Intermediate