Problem using VBA functions....
 

Hello All,

Function Celsius(dFahrenheit As Double) As Double
Celsius = (dFahrenheit - 32) * (5 / 9)
End Function

As a demo, I have been trying to get a simple VBA function to work
using Excel without success. I believe I've created it successfully
using the Visual Basic Script Editor. I have tried using it in a
worksheet, but whenever I try the formula in a cell, I keep getting
#NAME?.

EG. Cell A2 "=Celsius(3)"

No matter what I try to do, it will not accept this formula even
though I believe it's correct. From my investigation, it appears that
the worksheet for whatever reason cannot see this function I have
created, but I do no understand why.

Can anyone help?

In addition, I have installed the atpvbaen.xls and funcres.xla
add-ins. However, if I try to access these in the project manager, it
prompts me for a password (which I do not know). Is this normal?

Many thanks in advance,

Richard

BTW Subroutines do work under VBA.

Put the code in a regular code module (in the VBE, Insert/Module).




In article ,
(Richard Latter) wrote:

Hello All,

Function Celsius(dFahrenheit As Double) As Double
Celsius = (dFahrenheit - 32) * (5 / 9)
End Function

As a demo, I have been trying to get a simple VBA function to work
using Excel without success. I believe I've created it successfully
using the Visual Basic Script Editor. I have tried using it in a
worksheet, but whenever I try the formula in a cell, I keep getting
#NAME?.

EG. Cell A2 "=Celsius(3)"

No matter what I try to do, it will not accept this formula even
though I believe it's correct. From my investigation, it appears that
the worksheet for whatever reason cannot see this function I have
created, but I do no understand why.

Can anyone help?

In addition, I have installed the atpvbaen.xls and funcres.xla
add-ins. However, if I try to access these in the project manager, it
prompts me for a password (which I do not know). Is this normal?

Many thanks in advance,

Richard

BTW Subroutines do work under VBA.

Hi Richard

where did you put the function code .. if you put it in personal.xls you
need to prefix the function name with personal e.g.
=PERSONAL.XLS!Celsius(3)

to check if this is the case, use the fx (paste function) icon and the
user-defined category ... you should be able to see your function there.

Cheers
JulieD


"Richard Latter" wrote in message
om...
Hello All,

Function Celsius(dFahrenheit As Double) As Double
Celsius = (dFahrenheit - 32) * (5 / 9)
End Function

As a demo, I have been trying to get a simple VBA function to work
using Excel without success. I believe I've created it successfully
using the Visual Basic Script Editor. I have tried using it in a
worksheet, but whenever I try the formula in a cell, I keep getting
#NAME?.

EG. Cell A2 "=Celsius(3)"

No matter what I try to do, it will not accept this formula even
though I believe it's correct. From my investigation, it appears that
the worksheet for whatever reason cannot see this function I have
created, but I do no understand why.

Can anyone help?

In addition, I have installed the atpvbaen.xls and funcres.xla
add-ins. However, if I try to access these in the project manager, it
prompts me for a password (which I do not know). Is this normal?

Many thanks in advance,

Richard

BTW Subroutines do work under VBA.

On 28 Feb 2005 05:05:49 -0800, (Richard Latter)
wrote:

In addition, I have installed the atpvbaen.xls and funcres.xla
add-ins. However, if I try to access these in the project manager, it
prompts me for a password (which I do not know). Is this normal?

Yes, this is normal.

Those two are Excel add-ins and are protected.

You don't need those loaded to run your Function.

Follow the suggestions posted by Julie or JE.


Gord Dibben Excel MVP