how do i create help text to personal function?  
Author Message
NEDinMUNICH





PostPosted: Sun May 15 10:50:22 CDT 2005 Top

Excel Programming >> how do i create help text to personal function?

Hi,
Is it possible to ad help context to a personal function I create in vbe?
If yes then, how?
Thanks.
dov

Excel126  
 
 
David





PostPosted: Sun May 15 10:50:22 CDT 2005 Top

Excel Programming >> how do i create help text to personal function? It is not easy for you to add HELP to each argument of your User Defined Functions

The parameter cell will show up in the Function Wizard Help without any intervention, so choose your parameter names carefully. The
description can be entered as follows: Alt+F11 (VBE), F2 (View, Object Browser), Select the module (or <globals>) on left, select
the function on right, RClick, properties, fill in description.

To add a description for each argument will take a lot more work. Laurent Longre
has an addin to help with that -- more information and links to his addin at...

Entering a Description for the Function Wizard (Shift+F3): in XL2000
http://www.mvps.org/dmcritchie/excel/install.htm#fx
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


> Hi,
> Is it possible to add help context to a personal function I create in vbe?
> If yes then, how?
> Thanks.
> dov


begin 666 fx.jpg


M*S<O)BDT*2$B,$$Q-#D[/CX^)2Y$24,\2#<]/CO_VP!#`0H+"PX-#AP0$!P[
M*"(H.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SL[
M.SL[.SL[.SO_P `1" `0`! #`2(``A$!`Q$!_\0`%0`!`0``````````````

M% $!`````````````````````/_$`!01`0````````````````````#_W0`$



'9&\J! ?_V0``
`
end