Excel Articles

This page lists all articles currently available on this site (articles that fall under various categories will be listed at each one).

VBA

Create Addins: How to rework a macro so it is ready for distribution (as e.g. an addin)
Smart VBA Macro Recording (YouTube video), Presentation at the Excel Virtually Global conference, July 23rd, 2020
Handling Worksheet control events using a class module
How to put the CallByName function to use to find cells by a specified property.
A macro to change the formatting of cells so they only show a predefined number of significant digits
An example of how to disable your events
VBA Bug: Macro in Excel Stops After A Workbook.Open Command
How to use Parameters With Web Queries
An article about Registering a User Defined Function with Excel, showing how to show argument descriptions in the function wizard
A method to enable the user to undo changes done by your VBA routines
Getting a range from the user with VBA (Bug in Application.InputBox function)
Transpose a table of cells without garbling formulas
Docking your windows in the VBE
Updating addins through the internet
Installing An Excel Add-in Using Setup Factory (also shows how Excel add-ins are managed in the registry)
Working with Data Tables in Excel 2007 (VBA)
The Excel 2007 File format; Working with Worksheet data
The Excel 2007 File Format; Changing properties of Form controls
The Excel 2007 File Format; Editing elements in an OpenXML file using VBA
The Excel 2007 File Format; Adding RibbonX code to an Office OpenXML file using VBA
A simple Object listing tool
Catching Paste Operations (prevents wrecking of your validation)
Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox
Fixing links to UDFs in an addin
Editing elements in the OpenXML file using VBA
Preventing Workbook_Open event from running
Declaring API functions in 64 bit Office
Pivottable Slicers
Keeping modeless userforms on top of Excel
An MSForms (all VBA) treeview
A class module to measure performance of your VBA code
Building an Excel Add-in
Wheel of Fortune
Enabling Drag and Drop between two Listboxes on a VBA Userform

Various stuff

Defined names

Updated and greatly improved!!! Excel names: A paper about Excel's defined names.
Show a picture from a list of pictures
Charting a mathematical equation using just defined names

Trouble shooting

Corrupt files: Opening corrupt workbook files.
Startup problems: A list of things to do to fix them.
Working with Circular references in Excel
Co-authoring in Office 365. A great feature with an unexpected side-effect

Charting

Charting a mathematical equation using just defined names

Cell formatting

A macro to change the formatting of cells so they only show a predefined number of significant digits
Working with cell styles
Creating a user-friendly Data Validation in Excel Displaying help out of the way

Formulas

A small macro to wrap formulas in a range in an error test, from e.g. =Formula to =IF(ISERROR(Formula),"",Formula)
Transpose a table of cells without garbling formulas
Excel data table recipe, batchprocessing: how to calculate your model with many input values
Working with Circular references in Excel

Forms

External Data

How to use Parameters With Web Queries
Importing text files into your worksheets

User Defined functions

An article about Registering a User Defined Function with Excel, showing how to show argument descriptions in the function wizard

Other Applications

Installing An Excel Add-in Using Setup Factory (also shows how Excel add-ins are managed in the registry)

Fun

Web Analytics