MrExcel Consulting
Your One Stop for Excel Tips & Solutions

Formula Box / UDF Box

Posted by Jack in UK on December 21, 2001 1:17 PM

If i make a UDF the pop up box thats allows selection of argument range value whatever, how can i add my free text under when one argument i can discribe what to do???

Any ideas, Also what the VBA code to link the help file to say my help file or txt file

Thank you.

Posted by Juan Pablo G. on December 21, 2001 1:34 PM

You can "describe" the function by doing this. In Tools - Macro, you'll see a list of your Subs, but not your functions, doesn't matter, type in the "macro name" your function's name. You'll see that all the options enable them selves. Click "Options", and type in the Description, the description of your function.

Now, to describe what kind of variables you expect in your function (Type of parameters), this is a little tougher, doable, but it's more complicated.

Juan Pablo G.

Posted by Jack in UK on December 22, 2001 1:38 PM

Chers for that, works well, now to solve the comments to argument selection, so i can try to explain the argument and offer syntax example

Any clues?