Does anybody know if it is possible to add descriptions of arguements
for user-defined functions? I am referring to the window that appears
when you choose a user-defined function; the "Function Arguments"
window.

I was able to add a description of the function but I haven't figured
out how to add a description for the arguements.

Jonas,

I've never done this but I've read about a method that uses XLM (old-style
macros). I googled "xlm macro function arguments description" and got these
among others:

http://www.bettersolutions.com/excel...N723710331.htm

http://www.dailydoseofexcel.com/arch...on-with-excel/

hth,

Doug

"Jonas" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Does anybody know if it is possible to add descriptions of arguements
> for user-defined functions? I am referring to the window that appears
> when you choose a user-defined function; the "Function Arguments"
> window.
>
> I was able to add a description of the function but I haven't figured
> out how to add a description for the arguements.
>

Hello Jonas
You can add comments on your UDF very simply using the VBE Object Explorer:
When in VBE press F2 (to view the Object Explorer)
Select your project name from the top dropdown list (eg: VBAProject)
Right-click on your function in the "Global members" window
Select Properties
Add your comments and finsh with OK
Save your project
Return to Excel and insert your function, you should then be able to see
your comments in the Function argumenst window.

HTH
Cordially
Pascal

"Jonas" <(E-Mail Removed)> a écrit dans le message de news:
(E-Mail Removed)...
> Does anybody know if it is possible to add descriptions of arguements
> for user-defined functions? I am referring to the window that appears
> when you choose a user-defined function; the "Function Arguments"
> window.
>
> I was able to add a description of the function but I haven't figured
> out how to add a description for the arguements.
>

Jonas
Please replace:
Object Explorer with Object Browser
and
Global Members with Members of...

Cordially
Pascal

"papou" <(E-Mail Removed)> a écrit dans le message
de news: %23h%(E-Mail Removed)...
> Hello Jonas
> You can add comments on your UDF very simply using the VBE Object
> Explorer:
> When in VBE press F2 (to view the Object Explorer)
> Select your project name from the top dropdown list (eg: VBAProject)
> Right-click on your function in the "Global members" window
> Select Properties
> Add your comments and finsh with OK
> Save your project
> Return to Excel and insert your function, you should then be able to see
> your comments in the Function argumenst window.
>
> HTH
> Cordially
> Pascal
>
> "Jonas" <(E-Mail Removed)> a écrit dans le message de news:
> (E-Mail Removed)...
>> Does anybody know if it is possible to add descriptions of arguements
>> for user-defined functions? I am referring to the window that appears
>> when you choose a user-defined function; the "Function Arguments"
>> window.
>>
>> I was able to add a description of the function but I haven't figured
>> out how to add a description for the arguements.
>>
>
>

On Oct 18, 2:34 am, "papou"
<cpapounospamth...@laposte.netnospamthanks> wrote:
> Jonas
> Please replace:
> Object Explorer with Object Browser
> and
> Global Members with Members of...
>
> Cordially
> Pascal
>
> "papou" <cpapounospamth...@laposte.netnospamthanks> a écrit dans le message
> denews: %23h%23bDfVEIHA.2__BEGIN_MASK_n#9g02mG7!__...__END_MASK_i?a63jfAD$z__@TK2MSFTNGP02.phx.gbl...
>
>
>
> > Hello Jonas
> > You can add comments on your UDF very simply using the VBE Object
> > Explorer:
> > When in VBE press F2 (to view the Object Explorer)
> > Select your project name from the top dropdown list (eg: VBAProject)
> > Right-click on your function in the "Global members" window
> > Select Properties
> > Add your comments and finsh with OK
> > Save your project
> > Return to Excel and insert your function, you should then be able to see
> > your comments in the Function argumenst window.
>
> > HTH
> > Cordially
> > Pascal
>
> > "Jonas" <sun...@yahoo.com> a écrit dans le message de news:
> > 1192682038.554718.13...@i38g2000prf.googlegroups.com...
> >> Does anybody know if it is possible to add descriptions of arguements
> >> for user-defined functions? I am referring to the window that appears
> >> when you choose a user-defined function; the "Function Arguments"
> >> window.
>
> >> I was able to add a description of the function but I haven't figured
> >> out how to add a description for the arguements.- Hide quoted text -
>
> - Show quoted text -

Pascal,

Thanks for the response. However, already I knew how to add
description pertaining to the function. I want to be able to add a
description to an arguement. In addition to what Doug has written, I
might try to create a form that has my user-defined functions in it.
Maybe I can come up with some code that will have my form appear with
my functions rather than the dialog box that now appears when I choose
user-defined functions.

I'm surprised that the ability to do this isn't available in Excel
without creating a form. Maybe that is the problem, I'm not working
in Visual Studio; just Excel.

If you have any idea on how to associate a help file with the
function, please let me know. The section that I see for the place to
add it is grey and inaccessible.

You can add a brief description of your UDF by going to Tools>Macro>Macros.

Type in the name of your UDF and "Options". Add a description and hit OK then
Cancel.

To actually add the arguments you will need something more complex.

To fully customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

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

UNFORTUNATELY................Ballon/Screen Tips are not available with Laurent's
method.


Gord Dibben Excel MVP


On Wed, 17 Oct 2007 21:33:58 -0700, Jonas <(E-Mail Removed)> wrote:

>Does anybody know if it is possible to add descriptions of arguements
>for user-defined functions? I am referring to the window that appears
>when you choose a user-defined function; the "Function Arguments"
>window.
>
>I was able to add a description of the function but I haven't figured
>out how to add a description for the arguements.