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

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

A Class Module to Manipulate a Chart SERIES

Category: Developer Files | [Item URL]


Custom Number Formats

Category: General Files | [Item URL]

  • Description: This workbook contains several examples of useful custom number formats.
  • Has Macros? No
  • More Information: Click here
  • Download: custmfmt.xls

Array Formula Calendar

Category: General Files | [Item URL]

  • Description: This workbook contains a VBA macro that creates a "live" calendar in a worksheet. The days are displayed using a complex array formula. Change the month and year and the calendar updates. Once the calendar is created, you can copy the cells and paste them to another range, another sheet, or another workbook. The macro simply generates the formulas and is not necessary for the calendar to work.
  • Has Macros? Yes
  • Download: array formula calendar.xls

Page 3 of 5 pages
[Previous page]   [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