Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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.


Check out our Excel Resources

Re: Formula Box / UDF Box

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.


Re: Formula Box / UDF Box

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?


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.