test2 calls itself in an endless loop: that is probably not what you meant to do.

What should your code be doing?

--
Tim Williams
Palo Alto, CA


"ina" <roberta.inalbon@gmail.com> wrote in message news:1145894244.616161.316940@e56g2000cwe.googlegroups.com...
> Hello guys,
>
> I am newbie in VBA and I have an error 28: out of stack space; I do not
> understand why
>
> Sub test1()
>
> Dim cenom, cenonlala As String
>
> cenom = test2(cenonlala) ' I get this string name to input in my
> query
>
> End Sub
>
>
> Function test2(cenomtras As String) As String 'this function give me a
> string name
>
> cenonlala = "LALA"
>
> test2 = test2("LALA")
>
> End Function
>
>
> Can someone help me?
>
> Ina
>