View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn
 
Posts: n/a
Default How do I display "Help" Text in my own functions

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