I recently updated this popular PowerPoint add-in (17,568 downloads in the last 12 months) to support PowerPoint 2010 including the 64 bit version. For more see the updated blog post.
Archive of entries posted by Tushar Mehta
Bushy Trees
A favorite peeve of mine is code with “bushy trees.” I first saw this phrase in Kernighan and Plauger’s Elements of Programming Style.
Recently, I saw some code that checked if a RefEdit control referred to a single cell that contained a non negative integer. I cleaned up the formatting some since the original [...]
Automatically identify rows with an empty attribute
In a social.answers forum, Sue asked if there was a way to automatically copy rows that had a blank value in a particular column. See http://social.answers.microsoft.com/Forums/en-US/excslcreate/thread/dd6af3c8-5801-43c0-86f4-a668cdc3fd85
As a fan of using SQL, particularly through MS Query, I came up with the following.
Suppose we have a table with 3 columns, with a few empty values in [...]
Regular chart version of a sparkline
In one of the social.answers.microsoft.com web forums (Microsoft’s replacement for the newsgroups no longer hosted on its own server) someone wanted to see a regular chart version of a sparkline when s/he clicked on the cell. I thought that was an interesting idea since one can see much more detail in a large object [...]
TM Plot
The TM Plot add-in has undergone a major “behind the scenes” change. The default mechanism to specify a cell range in a userform has been the RefEdit control. However, some change Microsoft made in the recent past has resulted in some reports of problems with that control. Also, the control, while very [...]
Lightening colors
On an ongoing project, I had to create lighter shades of a color. Since we were working with Excel 2007, I decided to use Range.Interior.TintAndShade to achieve the desired result. TintAndShade is a number between -1 and 1 that lightens or darkens a color. Initial tests showed it seemed to work fine. [...]
TM AutoChart
This Excel add-in links the minimum, maximum, major, and minor values of a chart axis to worksheet cells.
For more see http://www.tushar-mehta.com/excel/software/autochart/index.html
Display a message for a specific duration
There are a number of instances where one may want to show a message for a specific duration. In other instances it might be for a specific duration or until the user acknowledges the message, whichever comes first. In the first category would be something like a splash screen or a very brief [...]
ByRef Arguments and the Application.Run Method
The Application.Run method is a versatile mechanism to call a subroutine particularly in another workbook or add-in. Its one documented limitation, if we want to call it that, is that all arguments are passed by value (ByVal). So, how does one pass an argument by reference (ByRef)?
For a version in a page by [...]