MATLAB: How to create contextual help information for MATLAB Functions deployed as Excel Add-Ins

definedexcelfunctionsMATLAB Compileruservba

How can I create contextual help information for MATLAB functions deployed as Excel Add Ins?

Excel provides tool-tips for function parameters for built-in functions:

Excel also provides a description of built-in functions while auto-completing:

How can I create this functionality for my MATLAB functions I deploy to Excel?

Best Answer

As of Excel 2016, it is not possible for User-Defined Functions (UDFs) to have the same kind of contextual help that built-in functions do. User Defined Functions are functions written in Visual Basic for Applications (VBA) which can be used as part of a formula for a cell.

From Excel's perspective the functions provided by a MATLAB-created Excel Add-In are just like any other User-Defined Function, so there is not any special way to achieve this functionality through an Add-In.

Related Solutions

MATLAB: How to return multiple outputs from an Excel Add-in function compiled using MATLAB Compiler SDK

You can use the Function Wizard to assist in returning function output to multiple cells, or ranges of cells, in a worksheet.

Key tasks in using the Function Wizard to achieve this goal are:

1) Install the Function Wizard.

2) Start the Function Wizard.

3) Select the option to incorporate your built COM component into Microsoft Excel.

4) Define the new MATLAB function you want to prototype by adding it to the Function Wizard and establishing input and output ranges.

5) Test your MATLAB function by executing it with the Function Wizard.

6) Create a macro.

7) Execute the macro you created using the Function Wizard.

8) Optionally inspect or modify the Microsoft® Visual Basic® code you generated with the COM component. Optionally, attach the macro you created to a GUI button.

Detailed instructions for each of these key tasks are available in the MATLAB Compiler documentation:

https://www.mathworks.com/help/compiler/excel/executing-functions-and-creating-macros-using-the-function-wizard.html

MATLAB: Can you call an Excel Add-in function, created with MATLAB Compiler SDK, from other VBA projects in Excel

Yes, you can call the Excel Add-in function programmatically from other VBA projects. One way to do this is by using "Application.Run", as shown below:

Function myFunc(Optional Arg1 As Variant, Optional Arg2 As Variant) As Variant
          myFunc = Application.Run("'myAddinFunc.xla'!myAddinFunc", Arg1, Arg2)
End Function

Where:

- "myFunc" is a function in a separate VBA project

- "myAddinFunc.xla" is the VBA project containing the add-in function created with MATLAB Compiler SDK

- "myAddinFunc" is the function to call in the add-in created with MATLAB Compiler SDK

- "Arg1" and "Arg2" are the arguments to pass to the function

Best Answer

Related Solutions

MATLAB: How to return multiple outputs from an Excel Add-in function compiled using MATLAB Compiler SDK

MATLAB: Can you call an Excel Add-in function, created with MATLAB Compiler SDK, from other VBA projects in Excel

Related Question