These pages contains add-ins for Microsoft Excel which I have developed in response to my needs. These add-ins are developed using Visual Basic for Application (VBA) in Excel.

Most engineers have used Excel spread sheet one way or another at 'sheet' level, but seldom venture into the VBA arena. Using VBA to create your own function, similar to Excel's built in functions, is one of the most useful applications.

These are the few add-ins I have written up to date. Please come back often, as I hope to add more to the list. Hope you find them useful and give your suggestions, if any.

Display Formula: Disfor() function

This is a very useful function if you like to show the workings of a design calculation. We always wish that the workings of a design calculation can be shown in steps as we do in manual calculations. This function is designed to display the formula with the values of the variables plugged in.

Example:

Cell A1: = 10, B1 :=20, C1 :=A1+B1 =30

D1:=disfor(C1) will display =10+20

For screen shot ,see the Display Formula :-Disfor() page.

The file containing Disfor() function is available for downloading.

 

Interpolation: Interpol() function

Excel's VLOOKUP and HLOOKUP is wonderful if the search data fall exactly on the data in a table. But in engineering application, usually the search data does not fall exactly on the data in a table. This interpolate function will come handy because it will return the answer by interpolating between the two nearest points.

Example: see Interpol() page.

The file containing Interpol() function is available for downloading.

Reference books:

 You can find more reference books at

Thanks to for hosting this page. Get your own free home page too.