custom functions argument preview

[shawnpeter]

Is there a way to have your arguments displayed when typing in a custom function into excel? For example when you type =if(... excel will show a tool tip showing =if(logical_test, [value if true], [value if false]...

thank you

 

[Clyde38]

Try this:

http://www.mrexcel.com/forum/showthread.php?t=405835

[link

http://www.linkedin.com/in/clydehancock

]

[/url]

 

[electricpete]

Go to insert menu and insert function... select category "user-defined", then click on your function and it will pull up a menu with arguments.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[IDS]

I don't know of a way to get the tool-tips.

You can get the function dialog from the function wizard, as pete said.

The blog post below gives two ways to add function specific help to the function dialog, an easy but limited way, and a more flexible but more difficult way.

http://newtonexcelbach.wordpress.com/2009/05/21/adding-function-categories-and-descriptions/

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[Clyde38]

Laurent Longre provides a free add-in (see post by Phox Jul 28th in the link I provided). FUNCUSTOMIZE.DLL at

http://xcell05.free.fr/english/index.html

[link

http://www.linkedin.com/in/clydehancock

]

[/url]

 

[shawnpeter]

thanks guys