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.