help with excel custom functions?

Question

Please help.

I have written my own functions in excel, and how do I get excel to display the arguments in the yellow box when using my function, the same way standard excel formulas work?

For example, if you use an IF formula, when you type " =if( " in a cell, excel gives you a prompt below the formula where "logical_test" appears in bold and the other arguments are in normal font. After you type " A1=A2, " [Value_if_true] " appears in bold, and so on through the syntax.

Is there a help switch or something I have left out? Because my function works fine, but I have to remember the sequence of arguments every time.

thanks.

cc

Answer 1

In the formula bar, there should be an "fx" button... this will give a dialog box prompting for all the tests in the formula.

Answer 2

Your code is ideal. Microsoft shows starting to be a module to enter such purposes. I created a module1 and entered your code there. It did not execute till I went to document then close and go back to Excel contained in the seen common Code Editor. The link below will take you to the Microsoft information superhighway web site with an celebration of precisely what you're trying to do.

Answer 3

I'm almost positive that I read somewhere that you can't add your own tooltips to your user-defined functions. Therefore, the best alternative when you can't remember the order of the arguments is to use the Insert Function dialog box.



Tim

http://feeds.feedburner.com/ExcelBlog

Answer 4

If you can't remember the formula you use, why don't you go to formula view, Ctrl ` and print out that way so you can see how you built it the first time around.

Answer 5

If there isn't a function button on the toolbar this will be found under " Insert " on Vista Home premium.