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

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/2...on-with-excel/

Hope this helps,

Hutch

"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

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