| Developing applications |
| |
Types of applications
Types of end-user
Analysing end-user needs
Planning an application
Planning the user interface
|
|
| Working with events |
| |
Overview
of event types
Event-handler procedures
Workbook events
Worksheet events
Chart events
UserForm events
Activate event
Save events
Change events
Focuse events
Click events |
|
| 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 |
|
| Custom menus |
| |
Testing to see if a menu exists
Creating a new menu
Adding items to a menu
Adding items to shortcut menus |
|
| File manipulation |
| |
Opening a text file
Writing a text file
Importing data from a text file
Searching for text in files
Verifying if a file exists
Listing all files in a given folder |
|
| Class modules |
| |
Class modules defined
When to use class modules
Creating a class module
Property procedures
Method procedures
|
|
View Basket
Recover Basket
MS Excel 2007 VBA Level 3 (2 days)