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


HTH,
JP


On Aug 6, 10:07*am, lawson wrote:
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(D24D68,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