Only other thing I can think of is to put the functions in an add-in.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"mworth01" wrote in
message ...

Thanks Bob. While that does obviously work, it seems a bit cumbersome
for the end user wishing to use that function. I assume that if you
knew of any other way of accomplishing the same task that you would
have mentioned it?

Also, is there a way to show the function tooltips of a UDF like the
standard Excel functions? For example, when you type =SUM( then a
yellow box appears showing you what you need to enter to make the SUM
function work - in this case it would be SUM(number1, [number2], ...).
I know that you can turn that feature off in Options, but is there a way
to make it appear for a UDF?

Thanks again.


--
mworth01
------------------------------------------------------------------------
mworth01's Profile:
http://www.excelforum.com/member.php...fo&userid=8991
View this thread: http://www.excelforum.com/showthread...hreadid=538657