Mail Merge Demo
Category: General Files / Developer Files | [Item URL]
- Description: Normally, Microsoft Word is used for mail merge operations. Word can perform a mail merge with data stored in an Excel workbook. The process works well, but in some cases it may be preferable to eliminate Word and do all of the work with Excel. This example demonstrates Word-less mail merge.
- Has Macros? Yes
- More Information: Click here
- Download: mailmerge.xls
Range Selection Demo
Category: Developer Files | [Item URL]
- Description: Contains 15 VBA procedures 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.
- Has Macros? Yes
- More Information: Click here
- Download: rangesel.xls
Permutation Demo
Category: Developer Files | [Item URL]
- Description: Demonstrates a recursive VBA procedure to generate all possible permutations of a text string.
- Has Macros? Yes
- More Information: Click here
- Download: permute.xls
Progress Indicator Demo
Category: Developer Files | [Item URL]
- Description: Demonstrates how to create a graphic progress indicator in a UserForm.
- Has Macros? Yes
- More Information: Click here
- Download: progind.xls
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
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: