XLL UDF: In Insert Function dialog, is it possible to display mandatory parameter names in bold, optional params in normal font?

Add-in Express™ Support Service
That's what is more important than anything else

XLL UDF: In Insert Function dialog, is it possible to display mandatory parameter names in bold, optional params in normal font?
Just like regular Excel functions e.g IF 
David Jones




Posts: 39
Joined: 2012-10-15
Hi there

Apologies if this has been asked before - I couldn't find it.

When you look at a regular Excel in-cell function in the Insert Function dialog, the names of the mandatory parameters are bold, the optional params are non-bold (have a look at the IF function for an example).

I have defined a (VB.NET) function with several optional parameters but all param names are shown in bold in the wizard. Is it possible to replicate the regular Excel function behaviour?

Thanks again

David
Posted 29 Nov, 2012 09:04:40 Top
Andrei Smolin


Add-in Express team


Posts: 14137
Joined: 2006-05-11
Hi David,

This is impossible. Excel knows about built-in functions; it treats them in a way which isn't availble for a UDF.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 29 Nov, 2012 10:14:23 Top
David Jones




Posts: 39
Joined: 2012-10-15
OK - thanks, Andrei. Is this also the reason why I don't get nice tooltips when I am entering one of my functions into a worksheet?

Dvid
Posted 29 Nov, 2012 11:46:38 Top
nwein




Posts: 510
Joined: 2011-03-28
Yes. If you would ever be able to get those tooltips (in editing mode) for UDFs, many people around the world would thank you dearly. The closest thing you can get can be achieved by clicking Ctrl+Shift+A while typing your UDF signature.
Posted 29 Nov, 2012 15:16:45 Top
Andrei Smolin


Add-in Express team


Posts: 14137
Joined: 2006-05-11
A nice shot. Thank you, Nir.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 30 Nov, 2012 01:37:39 Top