|
|
how do i create help text to personal function? |
|
Author |
Message |
NEDinMUNICH
|
Posted: 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
|
Posted: 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
|
|
|
|
|
|
|