Why can't I call my self-declared function?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello

I wrote this code in the General Declaration part of my Excel workbook (in
the VB environment):

Public Function jvdADD(Word1, Word2)
jvdADD = Word1 & Word2

End Function

Now, after saving the workbook, I expected to be able to call this function
from the standard environment of the workbook. For example I wrote in A3:
=jvdadd(a1,a2)

but it gave me:
#NAME?

how can I call that function from the standard environment of my workbook?

thank you


.

Relevant Pages

  • Re: simple one
    ... Custom Functions Can't Change Microsoft Excel Environment ... Ø Insert, delete, or format cells on the spreadsheet. ... Ø Move, rename, delete, or add sheets to a workbook. ...
    (microsoft.public.excel.misc)
  • Re: "Subscript Out of Range" Errors For Ranges
    ... It could also be the workbook with the range is not active. ... What is different about the environment when you click the button versus ... Hmm...they have the Internet on COMPUTERS now! ...
    (microsoft.public.excel.programming)
  • Re: Formula
    ... cell cannot change the environment of Microsoft Excel. ... Ø Move, rename, delete, or add sheets to a workbook. ... Ø Change any of the environment options, ...
    (microsoft.public.excel)
  • Re: VBA code to update row format
    ... environment \ workbook. ... problematic workbook, you may send it ... I did set break points, and I don't see anything unusual. ... "Norman Jones" wrote: ...
    (microsoft.public.excel.programming)
  • Re: Close file when inactive for 10 minutes.
    ... the thought of making it a shared workbook just crossed my mind... ... then doesn't saving it just make matters worse? ... I'd hate to be the developer of that ontime procedure when the user ... Instead of closing the file ...
    (microsoft.public.excel.programming)