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 •

Search Zoeken

WWW
This site

Go to Ga Naar
Home
Up
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

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

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

Defined names

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

Trouble shooting

bulletCorrupt files: Opening corrupt workbook files.
bulletStartup problems: A list of things to do to fix them.

Charting

bulletCharting a mathematical equation using just defined names

VBA

bulletCreate Addins: How to rework a macro so it is ready for distribution (as e.g. an addin)
bulletHandling Worksheet control events using a class module
bulletHow to put the CallByName function to use to find cells by a specified property.
bulletA macro to change the formatting of cells so they only show a predefined number of significant digits
bulletAn example of how to disable your events
bulletVBA Bug: Macro in Excel Stops After A Workbook.Open Command
bulletHow to use Parameters With Web Queries
bulletAn article about Registering a User Defined Function with Excel, showing how to show argument descriptions in the function wizard
bulletA method to enable the user to undo changes done by your VBA routines
bulletGetting a range from the user with VBA (Bug in Application.InputBox function)
bulletTranspose a table of cells without garbling formulas
bulletDocking your windows in the VBE
bulletUpdating addins through the internet
bulletInstalling An Excel Add-in Using Setup Factory (also shows how Excel add-ins are managed in the registry)
bulletWorking with Data Tables in Excel 2007 (VBA)
bulletA simple Object listing tool
bulletCatching Paste Operations (prevents wrecking of your validation)
bulletShowing An Array On A Form; Autosizing ColumnWidths Of A ListBox

Cell formatting

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

Formulas

bulletA small macro to wrap formulas in a range in an error test, from e.g. =Formula to =IF(ISERROR(Formula),"",Formula)
bulletTranspose a table of cells without garbling formulas

External Data

bulletHow to use Parameters With Web Queries

User Defined functions

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

Other Applications

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

    Subscribe in a reader

powered by longhead.com

Use the contact page to issue questions or comments about this website.
Copyright © 2003-2007 JKP Application Development Services.