I have created a UDF (named Interpolate) to interpolate within a user
selected table. The function works great when the function is created
in a module within the workbook that I call it. Since this seems to be
a handy function to use in the future, I tried to put it in my Personal
workbook so that I can access it in any workbook that I may be working
in. After doing this, I get the error "#NAME" when I try to use it in
another workbook. I declared the function as Public, even though I
think it does that by default. The function requires 3 inputs from the
user (Target, TableRng and ResultCol) and all other variables used to
define Interpolate are internal to the function (and declared with
Dim).

I'm assuming that I'm missing a statement which will allow this formula
to be used within any workbook. This seems like it should be a basic
question but searching this forum hasn't turned up anything yet. If
you have any advice I'd appreciate it. Thanks.


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

I have the same problem. My solution was to use an add-in

Die_Another_Day

Precede it with Personal.xls!, such as

=Personal.xls!MyFunc(MyParam)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"mworth01" wrote in
message ...

I have created a UDF (named Interpolate) to interpolate within a user
selected table. The function works great when the function is created
in a module within the workbook that I call it. Since this seems to be
a handy function to use in the future, I tried to put it in my Personal
workbook so that I can access it in any workbook that I may be working
in. After doing this, I get the error "#NAME" when I try to use it in
another workbook. I declared the function as Public, even though I
think it does that by default. The function requires 3 inputs from the
user (Target, TableRng and ResultCol) and all other variables used to
define Interpolate are internal to the function (and declared with
Dim).

I'm assuming that I'm missing a statement which will allow this formula
to be used within any workbook. This seems like it should be a basic
question but searching this forum hasn't turned up anything yet. If
you have any advice I'd appreciate it. Thanks.


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

Cool, thanks

Die_Another_Day

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

Take a look he

http://www.jkp-ads.com/Articles/DistributeMacro02.htm

Tooltips: No. But you could try and make help available in the function wizard:

http://www.jkp-ads.com/Articles/RegisterUDF00.htm

No easy stuff, though!

--
Kind regards,

Niek Otten

"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
|

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