Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Formula Box / UDF BoxPosted 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
|Check out our Excel Resources
Re: Formula Box / UDF BoxPosted 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 BoxPosted 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
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.