Clickable ImageMap Demo
Category: Developer Files | [Item URL]
- Description: Demonstrates how to create a clickable image map for navigation within a workbook.
- Has Macros? No
- More Information: Click here
- Download: imagemap.xls
Multiple UserForm Buttons With One Procedure
Category: Developer Files | [Item URL]
- Description: With a 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.
- Has Macros? Yes
- More Information: Click here
- Download: multiplebuttons.xls
Unique Items In A ListBox
Category: Developer Files | [Item URL]
- Description: Demonstrates a clever technique to fill a ListBox with non-duplicated items in a list.
- Has Macros? Yes
- More Information: Click here
- Download: nodupes.xls
A Color Picker Dialog Box
Category: Developer Files | [Item URL]
- Description: Demonstrates a custom VBA function that displays a UserForm that lets the user select a color. Uses a class module.
- Has Macros? Yes
- More Information: Click here
- Download: colorpicker.xls
Displaying Help Topics
Category: Developer Files | [Item URL]
- Description: This file demonstrates a technique that lets you display a series of help topics in a UserForm.
- Has Macros? Yes
- More Information: Click here
- Download: displayhelp.xls
Menu Maker
Category: Developer Files | [Item URL]
- Description: A table-driven technique that makes it very easy to create a custom menu for an Excel workbook or add-in. (Does not work with Excel 2007)
- Has Macros? Yes
- More Information: Click here
- Download: menumakr.xls
Display Charts In A UserForm
Category: Developer Files | [Item URL]
- Description: Demonstrates how to display one or more charts in a UserForm.
- Has Macros? Yes
- More Information: Click here
- Download: formcharts.xls
UserForm Hyperlink Demo
Category: Developer Files | [Item URL]
- Description: Demonstrates how to simulate hyperlinks on a UserForm.
- Has Macros? Yes
- More Information: Click here
- Download: hyperlinks.xls
GetOption Function
Category: Developer Files | [Item URL]
- Description: Demonstrates a useful VBA function the displays a list of OptionButtons derived from an array. The UserFrom and VBA code are created on the fly.
- Has Macros? Yes
- More Information: Click here
- Download: GetOption.xls
Soundex Demo
Category: Developer Files | [Item URL]
- Description: Demonstrates a technique that lets you search for a text based on how it sounds.
- Has Macros? No
- More Information: Click here
- Download: soundex.xls
Excel Downloads
This section contains free Excel workbooks and add-ins. With a few exceptions, all of these files were developed by me -- John Walkenbach. Some of the files demonstrate useful techniques that you can adapt to your own work. Others are simply for fun.
The files are grouped into three categories: General Interest, For Developers, and Add-Ins. The files may not be compatible with all versions of Excel.
All Downloads
Browse Downloads by Category
Also of Interest
How to download
Most of the download links point directly to Excel files, but a few are compressed ZIP files. For best results: