Welcome
The Million Man Month.... As of January, 2010, the web site is now being read by
over one million readers each month, pulling up about three million individual
pages.
This web site is brought to you as a public service by Chip
Pearson and Pearson Software Consulting, LLC. We provide complete
consulting and custom application design and development for Excel, Office, Visual Basic,
and the NET Framework in VB.NET and C#.
For more information about how to turn Excel into a powerful application platform,
contact Chip Pearson at (913) 549-4658.
This web site contains about 300 individual topic pages that together cover all aspects of
Excel, from simple formulas through Automation and COM Add Ins and into the NET
Framework. The content is aimed
at the intermediate level user although there is plenty of content for both beginners and advanced level users. Much
of the content is VB/VBA code, and those pages assume that you are
conversationally familiar with VB/VBA programming. I have been a professional computer programmer
for almost twenty years, ten years of that in the Windows/VB/VBA/Excel world.
The topics presented on the site are drawn from real world experience. There
are approximately 200 downloadable files, which include sample workbooks, VB/VBA modules,
VB Project source code and compiled DLL files.
The content of the site provides you with the tools you need to create
workbooks and VBA projects. Since it is impossible to be all things to all people,
the workbooks, formulas, and code examples are rather generic, allowing you to
readily customize them for your own particular needs. The formulas and
appearing on this site should work in any version of
Excel, version 97 or later, unless noted otherwise. Most of the VBA code should
work in Excel 97 and later, but I do make use of the enhanced features of VBA
version 6, which was introduced with Excel 2000.
Microsoft
Most Valuable Professional
Excel
1999 - 2008
Page Index
Topic Index
Search The Site
What's New
Contact Chip Pearson
chip@cpearson.com
Before you send me an email,
read this page.
Phone:
(913) 549-4658
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 a total of about 500 individual topic 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 20-Aug-2010)
Get The Last Used Cell In A Range (8-Aug-2010)
This page describes VBA code to find the last used (non-empty) cell of a range.
VBA Code To Extract Distinct Elements Of An Array (8-Aug-2010)
This page describes VBA code you can use to extract a list of distinct elements in an array for values.
A Quick And Easy Folder Listing (30-July-2010)
This page describes code for an easy way to create a directory listing. This code is much simpler and easier
to adapt than the Folder Tree code and add-in.
Avoiding Problems With Sheet Renaming (30-July-2010)
This page describes how to write code such that it will not fail if the user changes a worksheet's name.
Linked Listboxes (21-June-2010)
This page describes how to link multiple listboxes in a manner such that a change to one list box will
update the content of "downstream", linked listboxes.
Weighted Averages (9-June-2010)
This page describes weighted averages and formulas to calculate them.
The Split Function: A Better Way (20-April-2010)
The VBA Split function is a very useful function for breaking a text string into an array of its
constituent words. However, it as two limitations: first, you can't leave some string elements, such as quoted strings, as
individual elements. Second, it has problems when there are two consequtive delimiters. In this case, you get an empty array
element. This page describes a VBA function that fixes these problems.
Tracking Workbook Open And Close Operations (10-April-2010)
This page describes some event procedures you can use to track when and by whom a workbook is opened. While I
generally dislike such snooping by the boss, audit and security concerns do have their place.
Full File Names In Window Captions (8-April-2010)
This page describes some event code that you can use to display the full file name, including drive and path information, in the caption of
the main Excel application window and in the individual sheet window captions.
Where To Put The Code (6-April-2010)
This page describes where to put and how to use the code found on this web site and other venues. It describes how to use modules,
procedures, and snippets. This page is recommended for users who are relatively new to VBA programming.
Keeping Focus On A Worksheet When Showing A Form (18-March-2010)
This page describes VBA code to display a modeless user form but keep input focus on the worksheet.
Creating Multiple Subfolders (12-Feb-2010)
This page describes how to create a subdirectory structure of any depth with a single line of code.
Easter Calculations (30-Sept-2009)
This page describes how to calculate the date of Easter for a given year.
Wait Functions (12-Sept-2009)
This bas file contains the following functions. WaitForFileCreate, which waits for a specified file
to be created. WaitForFileClose, which wait for a specified file to be closed. And,
ShellAndWait, which executes a Shell command and waits for the Shell'd
program to finish. All these function support time-out values and break key handlers.
|
| |
|
 |
This page last updated: 12-February-2010. |
