Excel VBA

User-defined Functions

Alan’s Excel FAQ

Main Excel Page

Status Bar - 04/02/2008
Change Named Areas - 09/14/2006
Retrieve SQL Data - 09/14/2006
Build Multi-Dimension Array - 07/24/2006
Convert Lots of Tabs - 12/25/2005
Read Option Buttons - 10/02/2005
Using MultiPage - 10/02/2005
Custom Menu - 04/26/2005
Retirement Calculator - 01/16/2005
Odd and Even Rows - 01/06/2005
Stock Market Tracker - 08/11/2004
Build A Formula - 04/26/2004
Determine Parse Position - 04/17/2004
Parse Text File - 04/17/2004
Using Ubound - 04/17/2004
Compare List and Insert if Not Found - 03/10/2004
Write Contents of Multi Choice Box - 03/01/2004
Custom Document Properties - 11/15/2003
Move Minus (Revisited) - 09/12/2003
Move the Minus Sign to Front - 09/03/2003
Add Data to Next Row - 07/01/2003
Mail from Excel - 06/05/2003
Count Numeric Values in String - 06/03/2003
Write Error to Log - 05/21/2003
Pad Number of Digits - 09/19/2002
Count Occurences of a Digit - 08/24/2002
Extract Info from Text File - 08/17/2002
Count Occurences in String - 08/14/2002
Cascading Style Sheet - 08/05/2002
Write an ICS - 10/16/2001
Write a Text File - 08/18/2001
Add a Single Quote - 05/01/2001
HTML Color Chart - 09/07/2000
Custom Dialogs - 07/01/2000
Increment a Hour/Minute String - 07/01/2000
Populate Dialog - 06/14/2000
Produce Color Chart - 04/05/2000
Clean up Import - 05/01/1999
Change Case to Mixed - 04/01/1999
Trap Those Errors - 08/29/1998
Color Unlocked Cells - 08/08/1998
Multiple Page Numbers - 01/15/1997
Color Rows by Criteria - 03/15/1994

© 1994-2008

Updated:	04/02/2008 19:33