#Name for user function

[Guest]

I have written a function on the code for a sheet in my workbook eg

Public Function Test() As Double
return 1
End Function

However when I try to use it in a cell in my sheet like this =Test() I get a
#Name error.

What am I doing wrong?

 

[Jean-Yves]

Hi,

Put you Function in a standard module.
Regards,
Jean-Yves

 

[Haldun Alay]

Hi,
It should be
Public Function Test() As Double
Test=1
End Function

Kind Regards.
--
Haldun Alay
"donty" <[email protected]>, haber iletisinde ÅŸunları yazdı:[email protected]...
I have written a function on the code for a sheet in my workbook eg

Public Function Test() As Double
return 1
End Function

However when I try to use it in a cell in my sheet like this =Test() I get a
#Name error.

What am I doing wrong?

 

[keepITcool]

1.
change return 1
to Test = 1

2.
in VBE go to tools/options
and check the "require variable declarion" checkmark

this puts the line
OPTION EXPLICIT in the top of each new module
and will help prevent coding errors.

3. Buy a book on VBA. It's easy to learn, but a bit harder then getting to
work with excel. You'll need to study a bit..



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >