Missed the circ ref problem but that would become apparent only if the cell
were not formatted as text.


Gord

On Sat, 12 Dec 2009 23:57:23 -0000, "Bob Phillips"
wrote:

It is nothing to do with being formatted as text. You cannot have a function
and a value in a cell, one or the other.

So you can have a value in A1 and put this in A2, =Foo(A1), but not what you
are trying to do.


"Robert Crandal" wrote in message
...
I created my own function in Module1 which looks as follows:

Public Function Foo (ByVal strData as String)

Foo = "Hello World!" ' Return basic string

End Function


On my actual spreadsheet, cell "A1" is formatted as a "text"
type cell, there I cannot simply plug in my Foo() function
into cell "A1". I tried putting the following value into
cell "A1":
=Foo(A1)

If i enter that formula into cell A1 (which is a text cell), then
Excel will simply enter the above formula as a string, instread
of running the function.

So I guess my question is, how can I enter formulas into
cells that are formatted as "text"??

thank you