This web site is brought to you as a public service by Chip Pearson and
Pearson Software Consulting. We provide complete consulting and custom
application design and development for Excel, Office, and Visual Basic. For more
information about how to turn Excel into a powerful application platform,
contact Chip Pearson at (913) 432-5676.
The formulas and code appearing on this site should work in any version of
Excel, version 97 or later, unless noted otherwise.
Site News: Over the next few months, I will be converting
the web site from plain HTML to XHTML with ASP.NET 2.0. The existing HTML pages
will remain intact and new ASP pages will be added. It is possible that some
links may be broken during this transition. Please be patient.
Microsoft Most Valuable Professional
Excel
1999 - 2007
Page Index
Topic Index
Search The Site
What's New
Contact Chip Pearson
chip@cpearson.com
Phone:
(913) 432-5676
Note: This phone is for existing and new clients only. If you call,
please be prepared to pay for 1/2 hour of consulting time.
Please call after 9:00 AM USA Central Time Zone
|
What's New On The
Site
The list below shows only the ten or so most recent additions to the web
site out of over 190
pages. For a complete chronological list of updates, see
the What's New page. You can also locate
pages from the Page Index or the
Topic Index.
(Last Updated 1-July-2007)
Multiple Monitors
(1-July-2007)
This page describes how to use multiple monitors in Excel.
SaveCopyAndZip (16-May-2007)
This COM add-in lets you save a zipped copy of any open workbook, with
option password protection and file encryption.
Additional Functions On Colors
Page
Three new functions, AverageByColor, MinByColor, and MaxByColor have
been added to the Colors page.
ListBox Utilities
(11-March-2007)
This page contains about a dozen VBA procedures
designed to make the MSForms ListBox easier to use. The module includes
procedures for moving sets of list items up or down in the list box and
a sorting functions.
Recursive
Programming And The FileSystemObject
(10-March-2007)
Recursive programming, in which a procedure calls itself, it a powerful
programming technique. This page describes recursive programming using
the FileSystemObject to create a directory tree listing.
Updated Code For
Directory Tree Listing Add-In (5-March-2007)
New options have been added to the Directory Tree listing add-in.
Additional, a help file is available.
Suppressing
Events On A User Form (27-Feb-2007)
The Application.EnableEvents property
does not apply to events of controls on a UserForm. This pages describes
simple code you can use to implement your EnableEvents property of a
form.
Delete Blank Rows
(23-Feb-2007)
The DeleteBlankRows procedure has been completely rewritten to preserve
cell references and avoid #REF errors.
Testing
Whether A Series Of Numbers Is In The Correct Order (16-Feb-2007)
The formula described in this section of the page
determines whether a series of numbers in a column increases or
decreases by a specified interval. The formula returns 0 if all the
values are separated by the prescribed value, or a positive number
indicating the number of values out of order.
Insert
Procedure Names Automatically To VBA Code (15-Feb-2007)
This page contains a function called
InsertProcedureNameIntoProcedures and supporting function that allow you
to automatically insert the name of each procedure into that procedure
with a CONST declaration.
ShowAnyForm
(13-Feb-2007)
This pages describes how to show a UserForm that is to be determined at
runtime. It utilizes the often forgotten about VBA.UserForms object and
CallByName to access a form and its controls using string variables
whose values are set a run time.
Calling Functions In A COM Add-In or Automation Add-In From VBA
You can call the functions in a COM Add-In or Automation Add-In Public
Class from other VBA code, in addition to calling them from worksheet
cells. This pages describes how to call the functions from other VBA
procedures.
Building A Listing Of
Subfolders And Files (9-Feb-2007)
This page describes and has downloadable files for
creating a listing of all the subfolders and files (and their subfolders
and files) of any folder.
|
| |
|