SUMMER OFFER - only £595 a day!
Microsoft Excel VBA Macros Level 3 (2 days recommended)
This advanced course shows experienced Excel VBA developers how to develop Excel applications and work with VBA complex objects and concepts such as pivot tables, charts and class modules.
The course is suitable for those with good knowledge of Excel and experience of developing macros using VBA.
Course Outline
Excel applications
Types of applications
Speeding up your applications
Turning calculation off and on
Controlling screen updating
Turning off alert messages and warnings
Naming conventions
Code commenting
Saving versions
Handling Events
What are events?
Event Parameters
Enabling Events
Workbook events
Worksheet events
Charts
Specifying charts
Specifying an embedded chart
Naming embedded charts
Creating charts
Objects that comprise a chart
The Chart Area—VBA Name: ChartArea
The Plot Area—VBA Name: PlotArea
The Data Series—VBA Name: Series
The Chart Axes—VBA Name: Axis
Data Labels
Chart Title, Legend, and Data Table
VBA Names: ChartTitle,
HasLegend, and HasDataTable
Trendlines and Error Bars
Chart types
Settings for 3d charts
Settings for pie charts
Using events with charts
Exporting charts as images
Pivot Tables
Creating pivot tables
Using the PivotTableWizard
Creating a pivot table from the pivot cache
Connecting to external data
Pivot table methods and properties
Pivotcache methods and properties
File manipulation
Working with text files
Opening Text Files in Excel
Writing a text file
The Dir function
File Exists
Looping Through Files
Working with menus
Creating a custom menu
Deleting and Creating the Custom Menu
Adding a Single Menu Item
Breaking Items into Groups
Adding a fly-out menu
Creating a custom toolbar
Deleting and Creating the Toolbar
Adding Buttons to the Toolbar
Adding Drop-downs to the Toolbar
Remembering a toolbar's position
Class modules
Creating a new class
Adding methods
Creating properties
Read-Only Properties
Defining enumerations
Using raiseevent
Destroying object
View Basket
Recover Basket