Xll function missing or extra parameters management

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

Only registered users are allowed to subscribe.
Xll function missing or extra parameters management
 
Xavier N




Posts: 61
Joined: 2010-12-03
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
Windows 10 TH 2 - VS 2019 Community - Addin Express Release 9.4.4644
Posted 21 Aug, 2019 11:45:14 Top
nwein




Posts: 544
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




Posts: 61
Joined: 2010-12-03
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 !
Windows 10 TH 2 - VS 2019 Community - Addin Express Release 9.4.4644
Posted 22 Aug, 2019 02:02:21 Top