No function description and argument shown as I type xll UDF in the cell

chriswu · March 22nd, 2012, 5:43 pm

I build some UDF with XLW. These functions works pretty much the same as Excel built in functionswhen I use function wizard which can show all the help information for each argument.However, one difference I noticed is when I type the excel built in function in the cell, the function descriptionand argument shows automatically while UDF can't do that.Does any way know how to do that with UDF?Thanks

tomodachi · March 25th, 2012, 1:00 am

Have you tried xll.codeplex.com? It can do that too. They claim to make it possible to create chm help files that integrate into Excel, but I haven't been able to get that working. There seems to be a lot of crap after the install under Sandcastle. Hopefully they can get that working one day. XLW is kind of bloated too IMHO.

adcockj · March 26th, 2012, 6:49 am

QuoteOriginally posted by: chriswuDoes any way know how to do that with UDF?basically you can't, another one of the annoying ways excel udfs are different from internal functions.John

DavidJN · March 26th, 2012, 11:02 am

Yes you can. I started doing that 15 years ago. You can make your UDF indistinguishable from a native Excel function. Get a hold of the Excel SDK for details.

adcockj · March 26th, 2012, 11:13 am

QuoteOriginally posted by: DavidJNYou can make your UDF indistinguishable from a native Excel function. Get a hold of the Excel SDK for details.Really, in cell tooltips with parameter names .....I'd be delighted if you could point out where in the SDK this gets enabled.John

tomodachi · March 27th, 2012, 1:13 am

adcockj is right. Ctrl-Shit-A seems to be all you can do.