Quick Start |
Clone the xlltemplate library using git. Open xlltemplate.sln and build (F5). This will create xlltemplate.xll and open Excel with the add-in loaded. As you type =XLL.FUNCTION in a cell you should see it appear in intellisense. You can press TAB to complete the function name and Ctrl-Shift-A to insert the argument text.
The xll add-in library is open source so you can download it and build it yourself.
See an example of how to create an add-in