Using functions in string formatted cells
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
|