Handling MATLAB Events in Excel

Source code for Sept. 2006 News and Notes Programming Patterns article.

The Global Temperature Explorer application demonstrates how to integrate MATLAB GUIs into Excel by writing Visual Basic callbacks that can respond to events generated by the GUI.

The application consists of two parts, a COM component generated by MATLAB Builder for .NET, and a Visual Basic class module that integrates the COM component into Excel. The COM component consists of M-files and data files; it displays a data navigation GUI and exports two events: "DisplayLocation" and "PlotTempData". The Visual Basic
code contains callbacks that respond to the exported events and a macro used to launch the data navigation GUI.