'Office add in excel- Combination of task pane and udf
i created an office add in for excel (office.js / 365). The add in creates a sheet with a form. The user put values in the sheet, clicks on the button in the taskpane and the result of the calculations is put into the sheet.
Besides that i want to have a user defined function in the same office add in. The user should have the possibility to choose a cell and put his udf into it.
Is this combination possible? I did not find something in the net.
Solution 1:[1]
Yes, it is possible to define a function using an Excel web add-in. See Create custom functions in Excel for more information.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | Eugene Astafiev |