Downloads

RefTreeAnalyser

Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be!

Now there is the RefTreeAnalyser!

Name Manager

The Name Manager An excellent utility to manage defined names in your workbooks.

FlexFind

Flexfind eases searching and replacing throughout an entire workbook. Also enables you to search and replace strings in objects such as headers and footers, chart titles, buttons and many, many more.

Autosafe

The previous version is still available: Autosafe34.zip   (13 January 2003, 228k, downloaded: 5383 times) Note that this one shows a nag screen on networked computers.

Autosafe does not work on a Mac.

GoBack

Sometimes one has to edit a large workbook, with many worksheets. This tiny utility keeps a record of the ranges you have visited and gives you the opportunity to return to previous selections using two hot keys: control-alt-p to go to a previous selection and control-alt-n to go to the next. It also creates a toolbar with a dropdown to select a previous selection and  to disable/enable the utility.

FollowCellPointer

A small tool which follows your cell pointer by placing two arrows on top of your sheet pointing to the active cell. Does not change your formatting.

HeaderFooter

HeaderFooter.zip (28 January 2008, downloaded: 8733 times) Version 1.0 build 006.

Managing headers and footers in Excel can be a drag. This little tool helps you to change headers and footers in your files easily by means of a toolbar that shows dropdown/edit boxes in which you can type the header/footer codes directly or select them from the list of currently present header/footer codes in your file.

SetupUtility

SetupUtility.zip (Updated May 5, 2008, downloaded: 10792 times)

If you have created a nice add-in (see this article how to do that), a setup utility is an easy way for your users to install your addin. This free utility just needs you to change 4 cells to roll your own setup file.

Update: Now automatically removes invalid addins from addin list (courtesy: http://tinyurl.co.uk/zde9).

UpdateAnAddin

UpdateAnAddin.xls (Updated February 19, 2007, downloaded: 11260 times)

If you have created a nice add-in (see this article how to do that), an updating mechanism is an easy way to ensure your users get any bugfixes you did automatically . This download demonstrates how you can implement this functionality in your addin.

ShowTableOnUserform

ShowTableOnUserform.zip (14 May 2008, downloaded: 6127 times)

For a project I needed a quick way to display the content of an array to the user. I didn't want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. So I figured I'd put a listbox on a userform and make sure the column widths of the listbox resize with the data I want shown. That proved far from easy... See this article on how it works.

FixLinks2UDF

FixLinks2UDF.zip (02 June 2008, downloaded: 3514 times)

A demo file that handles #Name! errors for workbooks that use UDFs that reside in an add-in. See this article on how that works.

QueryManager

QueryManager.zip (Build 017, 23 September 2010, downloaded: 11321 times)

This utility has been developed together with Dick Kusleika. It eases the editing of queries and Pivottable connections. One can:

1. Edit the SQL string and the connect string of queries and PivotCaches

2. Add parameters

3. Change the path to the data source

All in a single dialog.

AutosafeVBE

AutosafeVBE.zip (build 026, 6 Aug 2007, 260k, downloaded: 15546 times)

This utility makes backup copies of VBA components to a user-defined directory. It keeps a user selectable number of copies of each component. It thus keeps a number of generations of your code as your work progresses, enabling you to return to a previous copy when things go wrong. Because it just exports the VBA components, it is unobtrusive because this process is relatively fast compared to saving your workbook or document. Excel and Word version included!!

Non linear Least Squares

ExcelVBEMultilineSR

ExcelVBEMultilineSR.zip (Version 1.0, Build 004, 27 Nov 2008, 634k, downloaded: 5251 times)

This utility enables you to do Search and Replace operations in the Visual Basic Editor of Excel. What is special about this tool is that you can search for multiple lines of code and replace with multiple lines of code.
WARNING: ALPHA VERSION, USE AT OWN RISK!

CopyVBAProject

CopyVBAProject.zip (Version 1.0, Build 007, 05 Oct 2007, 56k, downloaded: 5564 times)

This utility enables you to copy the components from the VBAProject of workbook A to Workbook B
Build 004: Existing modules are removed before copying.
USE AT OWN RISK!

ExportVBAProject

ExportVBAProject.zip (Version 1.0, Build 001, 14 Oct 2011, 24k, downloaded: 1597 times)

This utility enables you to copy the components from a VBAProject to a single text file. Very useful if you need to compare the VBA code of two Excel files. Use this handy tool to compare differences in the exported files: ExamDiff

ObjectLister

Objectlister.zip (Version 1.0, Build 003, 1 October 2008, 56k, downloaded: 8198 times) Lists objects, properties and methods of the selected object and enables you to quickly build code that uses many properties of an object. See the ObjectLister page for more information.

Treeview

Treeview.zip (build 023, 16 Apr 2013, downloaded 4 times) An All-VBA (MSforms) treeview control that makes the common controls treeview obsolete. Works in all Office versions as of Office 2000, including 64 bits and MAC office. See the accompanying article: An MSForms (all VBA) treeview

Treeview (Access mdb)

TreeviewOnAccessForm.zip (build 017, 18 Apr 2013, downloaded 6 times) An All-VBA (MSforms) treeview control that makes the common controls treeview obsolete. This is the same treeview as mentioned above, this time on an Access form. See the accompanying article: An MSForms (all VBA) treeview

AutoChrt

AutoChrt.zip (10 November 2000, 7k, downloaded: 16475 times)

Automates the process of creating graphs from database-like datasets, where you need to chart various columns against each other in x-y scatter charts to determine relationships between them. It consists of a sheet where to copy the data into and a sheet that holds the chart and some spinner-buttons to control which data are charted.

ChartAnEquation

ChartAnEquation.zip (May 1, 2005, 5K, downloaded: 8928 times)

Demonstrates a method to chart a mathematical equation using just defined names.
See this article for an explanation.

ControlHandler

ControlHandler.zip     (17 June 2005, 26k, downloaded: 7073 times)

Demonstrates a method to handle the events for multiple controls on a worksheet using a single class module. See this article for an explanation.

ControlLister

ControlLister.zip (1-10-2008, 21k, downloaded: 1082 times)

Tool that lists all controls on your userforms on a worksheet. Includes code to rebuild the userforms from the table. Note: does not handle userforms with multipage controls very well!

CatchPasteDemo

CatchPasteDemo.zip (17 Dec 2007, 21k, downloaded: 4948 times)

Demonstrates how to intercept paste operations in a workbook to prevent users from wrecking your validation. The download contains two workbooks; one for Excel 2003 and earlier, the other for Excel 2007 and 2010. See this article for an explanation.

UndoHandler

UndoHandler.zip     (8 March  2006, 24k, downloaded: 7223 times)

Demonstrates a method to enable the user to undo changes made by your VBA code. See this article for an explanation.

WatchOtherCell

WatchOtherCell.zip     (18 September 2012, 25k, downloaded: 7097 times)

This workbook simplifies looking at data in a sheet with a lot of columns. It shows the value of a cell on the same row in a column one can enter in a textbox. This way you can scroll all over the sheet and always (e.g.) have the value of a cell in column BE in view. Start the watcher by opening the file and using its entry in the Tools menu.

GetARange

GetARange.zip     (4 May 2006, 26k, downloaded: 9658 times)

This workbook demonstrates a bug in the VBA Application.InputBox function as described here. The workbook also contains a userform and sample code to work around that bug.

EditOpenXML

EditOpenXML.zip    (5 September 2011, 26k, downloaded: 4980 times)

Wouldn't it be useful to be able to edit the contents of an Office 2007 OpenXML file from within VBA? Well, now you can using this demo file. Find a full description here.

ModelessFormOnTop

ModelessformOnTop.zip (26 November 2012, downloaded: 304 times)

Excel 2013 now has a SDI as opposed to the MDI previous Excel versions have. This file demonstrates how to keep a modeless userform on top of the Excel 2013 window.  Find a full description here.

Arg2Name

Arg2Name.zip     (8 February 2001, 10k, downloaded: 14391 times)

This workbook demonstrates a trick to pass (range) arguments to defined name formula's. As published in David Hagers' EEE #9, available from John Walkenbach's web site. See the Excel names page.

xlMenuFunDict

xlMenuFunDict.zip   (29 Jan 2003, 810k, downloaded: 16517 times)

International versions of Office have the menu system in their local language. Also the Excel worksheet functions are (mostly) listed in local language. This complicates communication with the users with such a version. To aid in this process a utility has been devised that creates and shows a translation list of the Excel built-in command bars and controls and the Excel worksheet functions. This workbook can also list command bars of other Office software packages. It thus enables the international user who is using a different language version of Excel to quickly find translations for sequences of menu commands and function names.