Skip to content
Archive of entries posted on

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 acknowledgment of […]

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 itself […]