Hi,

I have created a UDF which I am using in a series of Work Sheets. Is it
possible to add help to the function so that when a user selects it from the
function wizard the help will be displayed?

Regards

Diarmuid

On Jan 5, 11:55*am, Diarmuid <Diarm...@discussions.microsoft.com>
wrote:
> Hi,
>
> I have created a UDF which I am using in a series of Work Sheets. Is it
> possible to add help to the function so that when a user selects it from the
> function wizard the help will be displayed?
>
> Regards
>
> Diarmuid

In the workbook press Alt+F8 and in the Macro Name Field type the
functions name, then click options, and in the Description field, type
a description for the function. then click ok.

Hi,

Unfortunately that wont work as the function wont appear in the macro list.
I am relatively new to this so there may be awayb of getting the function to
appear in the list. The function itself is written using visual basic.
Thanks for the tip though, its good to know that there is a way of adding
help to macros.

regards

Diarmuid

"GTVT06" wrote:

> On Jan 5, 11:55 am, Diarmuid <Diarm...@discussions.microsoft.com>
> wrote:
> > Hi,
> >
> > I have created a UDF which I am using in a series of Work Sheets. Is it
> > possible to add help to the function so that when a user selects it from the
> > function wizard the help will be displayed?
> >
> > Regards
> >
> > Diarmuid
>
> In the workbook press Alt+F8 and in the Macro Name Field type the
> functions name, then click options, and in the Description field, type
> a description for the function. then click ok.
>

On Jan 6, 6:17*am, Diarmuid <Diarm...@discussions.microsoft.com>
wrote:
> Hi,
>
> Unfortunately that wont work as the function wont appear in the macro list.. *
> I am relatively new to this so there may be awayb of getting the function to
> appear in the list. *The function itself is written using visual basic. *
> Thanks for the tip though, its good to know that there is a way of adding
> help to macros.
>
> regards
>
> Diarmuid
>
>
>
> "GTVT06" wrote:
> > On Jan 5, 11:55 am, Diarmuid <Diarm...@discussions.microsoft.com>
> > wrote:
> > > Hi,
>
> > > I have created a UDF which I am using in a series of Work Sheets. Is it
> > > possible to add help to the function so that when a user selects it from the
> > > function wizard the help will be displayed?
>
> > > Regards
>
> > > Diarmuid
>
> > In the workbook press Alt+F8 and in the Macro Name Field type the
> > functions name, then click options, and in the Description field, type
> > a description for the function. then click ok.- Hide quoted text -
>
> - Show quoted text -

Diarmuid,
It's not going to show up on the list. You have to manually key in the
name in the macro name field, and then the options button will be
accesible

You can add a brief description(not arguments) if you open the VBEditor and
View>Object Browser>Project/Library>yourworkbook.

Find your UDF and right-click>properties 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

Ballon Tips are not available with Laurent's method.


Gord Dibben Excel MVP

On Sun, 6 Jan 2008 04:17:01 -0800, Diarmuid <(E-Mail Removed)>
wrote:

>Hi,
>
>Unfortunately that wont work as the function wont appear in the macro list.
>I am relatively new to this so there may be awayb of getting the function to
>appear in the list. The function itself is written using visual basic.
>Thanks for the tip though, its good to know that there is a way of adding
>help to macros.
>
>regards
>
>Diarmuid
>
>"GTVT06" wrote:
>
>> On Jan 5, 11:55 am, Diarmuid <Diarm...@discussions.microsoft.com>
>> wrote:
>> > Hi,
>> >
>> > I have created a UDF which I am using in a series of Work Sheets. Is it
>> > possible to add help to the function so that when a user selects it from the
>> > function wizard the help will be displayed?
>> >
>> > Regards
>> >
>> > Diarmuid
>>
>> In the workbook press Alt+F8 and in the Macro Name Field type the
>> functions name, then click options, and in the Description field, type
>> a description for the function. then click ok.
>>