Excel Functions

[lawson]

Hello,

I have a macro function that has several options and looks like this:

=sf(D24,6,8,0)

For functions that came with excel, when you are writing the formula, excel
tells you the options available as you type each option. ie:

=if(D24>D68,1 [VALUE_IF_TRUE], 0 [VALUE_IF_FALSE])

I would like my function to display the options as you type as well.

Thank you for your help

lawson

 

[Tom Hutchins]

Unless it is a new feature in Excel 2007 (and I am pretty sure it is not),
Excel has never provided a way to do this. Here is a link to a workaround
method:

http://www.dicks-blog.com/archives/2006/02/17/registering-a-user-defined-function-with-excel/

Hope this helps,

Hutch

 

[JP]

See http://www.jkp-ads.com/Articles/RegisterUDF00.htm


HTH,
JP