Light Box Demo

Category: Developer Files | [Item URL]

  • Description: You've seen Web sites that "go dim" when a window is displayed on top of the page. This is known as a light box effect. This file contains VBA code that demonstrates how to get a similar effect in Excel. It displays a UserForm or a Message Box while Excel's window is darkened.
  • Has Macros? Yes
  • More Information: Click here
  • Download: xllightbox.xls

Functions To Quantify Color Contrast

Category: General Files / Developer Files | [Item URL]

  • Description: This workbook contains VBA functions that can help you select legible colors for cell background and text.
  • Has Macros? Yes
  • More Information: Click here
  • Download: color-difference.xls

Generate A Word Frequency List

Category: General Files / Developer Files | [Item URL]

  • Description: A workbook that demonstrates a VBA macro that creates a word frequency list. Put your text in Column A, with no blank cells. The text can consist of sentences, titles, etc. Run the macro, and you get a pivot table that lists every word, and the number of times it's used. The demo file contains three examples: Beatles song titles, the first few paragraphs of Moby Dick, and a George W. Bush speech.
  • Has Macros? Yes
  • More Information: Click here
  • Download: wordfrequency.xls

Display Disk Drive Information

Category: General Files / Developer Files | [Item URL]

  • Description: Contains VBA macros that display information about the drives attached to your system. It uses three functions: DriveType, DriveSize, and DriveSpaceFree.
  • Has Macros? Yes
  • More Information: Click here
  • Download: driveinfo.xls

Slide Show Demo

Category: General Files / Developer Files | [Item URL]

  • Description: Demonstrates a simple VBA macro that displays a full-screen slide show of all embedded charts on a worksheet.
  • Has Macros? Yes
  • More Information: Click here
  • Download: chart slide show.xls

MP3 File Lister

Category: General Files / Developer Files | [Item URL]

  • Description: An Excel application that generates a list of MP3 files. To use it, click the 'Start" button and you will be prompted for a directory. The list includes the directory you choose, plus all nested subdirectories. When the macro finishes, the worksheet will contain a list of MP3 files with the following columns: Path, Filename, Artist, Album, Title, Track, Genre, Duration, and Size. The data can be summarized in a pivot table. This is not the fastest application, so be patient (the status bar displays the current file number).

    This workbook requires a reference to Microsoft Shell Controls and Automation (shell32.dll). If it doesn't work for you, check the reference using Tools - References in the VB Editor. The VB Project is not protected, so you can view the code or modify it to suit your needs.
  • Has Macros? Yes
  • Download: mp3filelister.xls

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

Page 1 of 3 pages
[Next page]

Search Downloads


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:

  1. Right-click the download link
  2. From the shortcut menu, choose Save Link As or Save Target As
  3. Specify the location for the downloaded file.
© Copyright 2017, J-Walk & Associates, Inc.
Privacy Policy