View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default excel customised function with help

Gabriel

You can add a brief description(not arguments) if you open the VBEditor and
ViewObject Browser.

Find your UDF and right-click and you can add a comment there.

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

AFAIK the Excel built-in Functions cannot be modified.

Gord Dibben Excel MVP

On 7 Aug 2004 17:06:14 -0700, (Gabriel) wrote:

Hi,

Is there a way to attach a help to a customized function in excel vba,
just like there exist for any excel function?

Thank you
Gabriel