How do I display "Help" Text in my own functions

[Gazzr]

Hi All,

I am designing my own functions and was wondering how I add the “Help” text that appears at the bottom of the grey box you see when you double click the funtion name.

EG for the =sum function you see “Adds all the numbers in a range of cells”. Below this there is also text giving information on each argument.

Hos do I code this?

Regards
Garry

[Kevin Vaughn]

You can add a description for your function. Try this. Hit Alt-F8 (or
however you bring up the Macro box,) since you are dealing with a function,
its name won't appear so you have to type it in. When you do, you should be
able to choose Options. Click Options and enter your description. However,
last I heard there is no way to give help for your argument list.

--
Kevin Vaughn


"Gazzr" wrote:

>
> Hi All,
>
> I am designing my own functions and was wondering how I add the “Help”
> text that appears at the bottom of the grey box you see when you double
> click the funtion name.
>
> EG for the =sum function you see “Adds all the numbers in a range of
> cells”. Below this there is also text giving information on each
> argument.
>
> Hos do I code this?
>
> Regards
> Garry
>
>
> --
> Gazzr
> ------------------------------------------------------------------------
> Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
> View this thread: http://www.excelforum.com/showthread...hreadid=515629
>
>