Dear all,

this must be a common problem, and I thought I found the solution, but
it doesn't work ... I'm probably missing something very simple.

I want to execute a simple VB function in one cell, taking another cell
as Parameter. Both, parameter cell and function result are strings. For
example:

A1: "this is content of cell A1"
A2: =Convert(A1)

and Convert is a VB function

Function Convert(content As string) as String

' do something depending on content
Convert = "result-string"
End Function


However, I always get a #NAME? Error in cell A2.

The idea is of course, that I don't want to explicitly execute a macro
by hand, but have something similar to A2 = A1*2, just for a function all.

How do I do this kind of exercise properly?

Thanks a lot,

Riko