Excel VBA Training - level 2
Training
In London
Description
-
Type
Training
-
Level
Intermediate
-
Location
London
-
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. This course delves deeper into the Excel object model and provides delegates with practical experience of developing their own VBA solutions.
Facilities
Location
Start date
Start date
Reviews
Subjects
- Excel
- Property
- MS Excel
- Setting
- Hierarchy
- InputBox
- DisplayAlerts
- Alerts property
- Cut Copy
- Dialogue boxes
Course programme
About classes and objects, Objects and collections, The hierarchy of objects, Properties, methods and events, The Locals Window, The Immediate Window
Function proceduresSub versus function, User-defined functions, Declaring a function, Calling a function, Private and public scope, Defining arguments, Optional arguments
The Application objectWhen to use, ScreenUpdating property, DisplayAlerts property, Setting CutCopyMode to false
Dialogue boxesMsgBox function, InputBox function, Application.Dialogs
UserFormsCreating 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 worksheetsThe Workbooks collection, The Sheets collections, The Window objects, Workbook events
Ranges and namesColumn and Row properties, CurrentRegion property, The Union method, The Intersect method, Using the Name property, Working with named ranges
Pivot tablesPivot table code overview, Creating a pivot table, PivotField object, PivotItems collection, Modifying a pivot table, Using external data
Charts and drawingsAbout 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
Excel VBA Training - level 2