displaying udf parameters when called from excel cell (1 Viewer)

CJ_London

Super Moderator
Staff member
Local time
Today, 05:59
Joined
Feb 19, 2013
Messages
16,553
Using Excel 2010 and later.

I have udf, stored in a module with two parameters. It works fine. The issue is when calling it.

If the udf is called from vba code, the names of the parameters are displayed.

However if the udf is called from a worksheet cell, although the function appears in the list, when selected the parameters do not appear.

I know I can click on the fx button, but would prefer it worked the same way as when using say =vlookup

Am I missing something basic or is it simply not possible?

Thanks in advance
 

Ranman256

Well-known member
Local time
Today, 01:59
Joined
Apr 9, 2015
Messages
4,339
parameters do not normally appear in the cell.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 05:59
Joined
Feb 19, 2013
Messages
16,553
Hi Ranman,

they do for standard functions e.g.



Just trying to get the same for a udf....
 

Attachments

  • Capture.JPG
    Capture.JPG
    15 KB · Views: 243

Users who are viewing this thread

Top Bottom