| October 29, 2006 |
Added draft chapter on
The Power of Names and
Formatting a Formula to the book
Business Data
Management with Microsoft Excel |
| October 4, 2006 |
Added a VBA tip on
Property procedures in a standard module |
| September 23, 2006 |
Added a new solution to the Case
Studies book:
Audio
alerts |
| September 21, 2006 |
Added a draft chapter on the
Power of Variants
to the VBA programming book. |
| September 1, 2006 |
Added new software that supports
an
enhanced find capability |
| July 31, 2006 |
Demonstrates a few user interfaces
more in-line with what the customer might expect rather than the
default Excel interfaces. This uses a simple problem of how to
convert a phone "number" containing letters into one that has only
numbers.
   |
| July 23, 2006 |
My first Google gadget |
| July 21, 2006 |
|
| July 18, 2006 |
Revised the Excel tip that uses
VBA:
Excel and Hyperlinks. |
| July 17, 2006 |
Revised the
Plot
magnitude difference page
 |
| July 16, 2006 |
Added a RSS feed
 |
| July 15, 2006 |
 Added
a tutorial on conditionally coloring shapes. It illustrates
how one can use Excel to create visual representation of data other
than in charts and worksheets. |
| July 10, 2006 |
Added the
Using VBA to Work with
Multiple Sheets Simultaneously page. This addresses an
important but not often used or discussed programmatic use of an Excel
capability. |
| July 8, 2006 |
My first Google gadget
The gadget adds a large digital time display to the
personalized Google homepage. Additional features include a
12/24 hour display, optional display of seconds, and the ability to
view the time in any other timezone. Click the image below to
learn more.
|
| July 8, 2006 |
Redid the "About this site"
section. Improved the right "border." |
