Excel Functions
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 |
Excel Functions
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 |
Excel Functions
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 |
All times are GMT +1. The time now is 12:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com