Apologies for hanging this on your post Nick, but don't have the original and
too lazy bring it back.

Ebers

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

UNFOTUNATELY................Ballon/Screen Tips are not available with Laurent's
method.


Gord Dibben Excel MVP

On Wed, 26 Jul 2006 10:47:50 +0800, "NickHK" wrote:

Not sure what you mean by ScreenTip;
- Something to do the Mac version ?
- Using the Assistant ?
- Excel 2002 or higher ?
I don't use any of these, but...
You can add a description to your function. Go to the Object Browser, select
VBA Project, navigate to your function, right-click, Properties and enter
the text you want.
This description appears when you click the "=" to the left of the formula
bar.

NickHK


"Ebers" wrote in message
...
I would like to have a ScreenTips message show up when the Excel user
begins
to type a function I created in VBA. The message would explain what the
arguements in the function are, much the same way the built in functions
such
as SUM and AVERAGE do when you start entering them. I'm aware of comment
and
data validation notes that can appear when a cell is selected, but I want
something that will appear when the function is being typed into any cell
in
a given workbook.
Thanks.


Gord Dibben MS Excel MVP