Charts, Graphics, and Sound
- Removing Lines From a Surface Chart
A VBA procedure to remove the lines from a surface chart. - Chart Trendline Formulas
Formulas that enable you to generate data points for a chart's trendline. - Playing a Sound Based on a Cell's Value
A worksheet function that will play a WAV file, based on a condition you specify. - A Class Module to Manipulate a Chart SERIES
A useful class module that makes it easy to work with data used by a chart. - Displaying a Chart in a UserForm
A technique that lets you display a chart as an image in a UserForm. - Playing Sound From Excel
API calls to play WAV or MIDI files from Excel. - Creating an ImageMap
Demonstrates how to set up a clickable image map for navigation (includes a sample file). - Creating a "Splash Screen" for an Excel Workbook
A simple technique that displays a dialog box for a specified period of time when your workbook is opened. - Creating a Worksheet Map:
A useful utility that creates a map for a worksheet. The map color-codes each cell by type (text, number, or formula).