View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
david mcritchie david mcritchie is offline
external usenet poster
 
Posts: 691
Default 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

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