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