How can I get intellisense to work for UDFs in XLAM files?

Question

I have some UDFs in an XLAM file. Intellisense doesn't seem to pickup these UDFs when the XLAM is installed as an add-in. The UDFs themselves work fine in Excel, its just that they don't appear in intellisense. Here I mean intellisense when used on a worksheet.

Answer 1

There (is) was no way of getting a UDF (VBA, XLL etc) to supply intellisense. This has often been suggested to the Excel team as a worthwhile improvement.

(see https://fastexcel.wordpress.com/2016/10/07/writing-efficient-vba-udfs-part-15-adding-intellisense-to-your-udfs/)