The Samples.xls workbook contains twelve worksheets: a table of contents
worksheet, ten worksheets that are dedicated to a specific topic, and one worksheet that returns you back to the table of contents.
Contents
This worksheet contains introductory information, disclaimers, and links
to the other worksheets.
Worksheet Functions
This worksheet contains sample formulas for completing common spreadsheet tasks, such as:
- Suppressing the display of error values in formulas.
- Indexing, matching, and looking up values by using the Lookup Wizard.
- Calculating formulas based on conditions.
Conditional Formatting
This worksheet provides two examples that demonstrate how to change cell formatting depending on the current value of the cell.
Data Validation
This worksheet provides examples for setting up restrictions for values that can be entered into a cell.
Chart Labeling
This worksheet demonstrates how to add labels to points in an xy (scatter) chart programmatically. It provides sample data, a sample chart, and a link to the Visual Basic macros that create and remove the labels.
Repeating Tasks
This worksheet contains information about using different types of
loops in Visual Basic macros:
For Each...
Next loops,
For...
Next loops, and
Do... loops. The worksheet contains links to four Visual Basic modules that contain sample code.
Arrays
This worksheet contains information about using arrays in Visual Basic for
Applications macros. The worksheet contains links to two Visual Basic modules that contain sample code.
API (Application Programming Interface) Examples
This worksheet contains nine examples for using API calls from within the programming environment in Excel.
Events
This worksheet contains information about having a certain event trigger a macro to perform a specific task. The events that are covered include
BeforeDoubleClick,
Change, and
BeforeClose. Sample code is contained in this worksheet.
Automation
This worksheet contains information about automating tasks between Excel and other Office programs, such as Microsoft Word, Microsoft
Access, Microsoft PowerPoint, and Microsoft Outlook. Links to sample code are included.
ADO-ActiveX Data Objects
This worksheet provides examples that illustrate common database tasks with code. It includes numerous links to sample Visual Basic macros.