Excel Articles

JKP Application Development Services.

Microsoft Office Application Development

Excel Articles

Up • News • Excel Headlines • Products • Recommendations • Services • Contact • Excel Articles • Excel Books • Downloads • Links • All Comments • Search

• Defined Names • Corrupt Files • Create Addins • Startup Problems • Chart an Equation • Show Picture • Round2Digits • Control Events • Custom Find • FormulaWrapper • Disable Events • Workbook Open Bug • WebQuery • Register UDFs • Undo With Excel VBA • Select a range (VBA) • Transpose Table • Docking VBE Windows • Excel 2007 Tables • Excel 2007 Tables (VBA) • Update An Addin • Addin Installation • Object Lister • Excel 2007 FileFormat • Catch Paste • Listbox AutoSize • Fix Links to UDFs •

Search

Zoeken

Donate	Donaties
Did you find something helpful on my site? Consider a donation! Heeft u iets gevonden waar u wat aan had? Overweeg dan een donatie!

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

Excel 2007

	Working with Data Tables in Excel 2007
	Working with Data Tables in Excel 2007 (VBA)
	The Excel 2007 File format; Working with Worksheet data

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.

Charting

Charting a mathematical equation using just defined names

VBA

Create Addins: How to rework a macro so it is ready for distribution (as e.g. an addin)

	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)
	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 UDF's in an addin

Cell formatting

A macro to change the formatting of cells so they only show a predefined number of significant digits

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

External Data

How to use Parameters With Web Queries

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)

Subscribe in a reader