Excel Files: For Developers

Excel page

User tips

Developer tips

Excel FAQs

Excel files

Excel Expert E-Letter

Excel Help Resources

Excel links

Excel oddities

Excel books

Power Utility Pak for Excel

Free Downloads

The files listed below may be of interest to Excel developers. These files demonstrate various UserForm and VBA techniques. Note that not all files work with all versions of Excel.

NOTE:
These files are all self-extracting EXE files. To unpack them, just execute the file. After the file is extracted, you can delete the EXE file.

Indicates a popular download.

File	Excel Version	Size	Links
MP3 File Lister A macro-driven application that creates an attractive listing of MP3 music files.	2000 and later	152K	More Info
A Class Module to Manipulate a Chart SERIES A useful class module that makes it easy to work with the data used by a chart.	97 and later	94K	More Info
Power Utility Pak v6 A collection of Excel utilities, functions, and enhanced shortcut menus. The complete VBA source code is available for a very small fee.	2000 and later	2354K	More Info
J-Walk Enhanced Data Form Add-In Version 2.0. An alternative to Excel's Data * Form command. Lots of enhancements, and the VBA source code is available (for a small fee) so you can customize it.	97 and later	353K	More Info
Soundex Demo Demonstrates a technique that lets you search for a text based on its sound.	97 and later	130K	More Info
GetOption Function  Demonstrates a useful function the displays a list of OptionButtons derived from an array. The UserFrom and VBA code are created on the fly.	97 and later	66K	More Info
Control the LED Display in the StatusBar Originally developed by David Wiseman. It consists of VBA code that lets you control the "LED" display in Excel's status bar. I've always thought that this display was off limits, but David proved otherwise with some incredible programming. Very impressive! Thanks to David for letting me share this file with the world, and thanks to Jim Rech for modifying it so it works with Excel 2000. This updated version is in the form of a class module (expertly programmed by Ole P. Erlandsen).	Excel 5 and later	116K	Download
UserForm Hyperlink Demo Demonstrates how to add hyperlinks to a UserForm Click	97 and later	57K	More Info
J-Walk FaceID Identifier Add-In Makes it very easy to determine the FaceID value for a CommandBar image.	97 and later	160K	More Info
Charts in a UserForm Demonstrates how to display one or more charts in an Excel 97 UserForm.	97 and later	60K	More Info
Menu Maker A technique that makes it very easy to create a custom menu for an Excel 97 (or later) workbook or add-in. VBA programming not required!	97 and later	61K	More Info
Displaying Online Help A technique that makes it easy to display help topics in a UserForm.	97 and later	64K	More Info
A Color Picker Dialog Box Demonstrates a custom VBA function that displays a UserForm that lets the user select a color. Uses a class module.	97 and later	67K	More Info
Filling a ListBox With Unique Items A clever technique to fill a ListBox with non-duplicated items in a list.	97 and later	61K	More Info
Handle Multiple UserForm Buttons With One Procedure With an Excel 97/2000 UserForm, each control on the form has its own unique Click event, so you can't have several buttons that call the same Sub procedure. This workbook demonstrates a way around this limitation by using a class module.	97 and later	59K	More Info
ImageMap Demo Demonstrates how to create a clickable image map for navigation within a workbook.	97 and later	68K	More Info
Animated Shapes Demonstrates how to use VBA to generate some interesting animations using shapes and charts.	97 and later	73K	Download
Progress Indicator Demonstrates how to create a graphic progress indicator in a UserForm.	97 and later	60K	More Info
Dialog-To-UserForm Wizard A handy utility that converts Excel 5/95 dialog sheets to Excel 97/2000 UserForms.	97 and later	80K	More Info
Generate Permutations Uses a recursive procedure to generate all possible permutations of a sting.	5 and later	42K	More Info
Copy Multiple Selection A VBA macro that lets you copy and paste a multiple range selection -- something that's normally impossible.	5 and later	40K	Download
Button Faces Contains nearly 200 custom toolbar button faces that you can copy. These are not Excel 97/2000 CommandBar images. For Excel 5/95.	5 and later	56K	Download
Range Selection Demonstration Contains 15 VBA routines that demonstrate how to make various types of range selections. When you open the workbook, a new menu appears that lets you try out the various routines.	5 and later	46K	Download

• General Interest Files