Xll function missing or extra parameters management

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

Xll function missing or extra parameters management
 
Xavier N


Guest


Hello,
When you insert a builtin function in a cell (directly or using the insert formula dialog box), Excel prevent you from omitting parameter or adding extra parameter by displaying extra dialogs box explaining there is an error / too much arguments.
But none of these dialog box display when you insert a custom user defined function (from your xll) and you omit or add extra argument?Â?Ð??

Do some of you find a solution to display these dialog box in case of missing or extra parameters ?

Regards
Xavier
Posted 21 Aug, 2019 11:45:14 Top
nwein




Posts: 577
 Joined: 2011-03-28
The best you can do with UDFs is click Ctrl+Shift+A which will show the UDF signature (not as a function screentip, but actually in the editor). Other than that - there's nothing else that can be done.
Posted 21 Aug, 2019 13:32:30 Top
Xavier N


Guest


Thanks nwein for this tip. I usually call the insert function dialog box and i didn't know it..

It seems Microsoft does not integrate a check omitted/extra argument mechanism for UDFs. And it would be too much work to develop a custom formula checker in a excel worksheet change event !
Posted 22 Aug, 2019 02:02:21 Top