Heat Transfer Today

Educational Software for
Heat and Mass Transfer

Excel Workbooks

HTTdemosub: A spreadsheet demonstrating a lot of features of Excel and VBA Primer

UPDATED: 09/11/2022

This single workbook includes examples of the use of buttons, scrollbars, functions, subroutines, named ranges, user forms and even narration.   These objects are pretty much everything you need to get started using Visual Basic for Applications within Excel.    If you have ever done any structured programming, then this one workbook shows you how to use that skill in tandem with Excel.   You can use Excel’s graphing and charting capability for displaying output, while doing the number crunching in the background using VBA.   You can use VBA with other MS Office applications as well as within some third-party (non-Microsoft) packages like AutoCAD and SolidWorks.  For instance, you might have the equation for a curve or surface.  Using VBA, you can put that information directly into your AutoCAD or SolidWorks design.

Interface for HTTdemosub.xlsm, which goes with the Excel/VBA primer

General Reference on Use of VBA with Excel (VBAPrimer.pdf) – Updated 6/4/2018:

Ribando, R.J., “An Excel/Visual Basic for Applications (VBA) Primer,” Computers in Education Journal, Vol. VIII, No. 2, April-June 1998, pp. 38-43. A version of this article updated for Excel 2007 and newer may be found here.

© 2021 Heat Transfer Today – All Rights Reserved.