End statement on the Return

Question

I have a function.  The function has a return.
Sub sub1
y=function1(x)
End Sub

Function function1(ByVal x as integer)
data1(1)=1
data1(2)=3
data1(3)=8
Return data1(x)
end function

Why is it asking me for an end statement on the Return statement? And how will this work on a spreadsheet?

Answer 1

Hi ,
to return a value in a function you don't use Return but FunctionName= Value, so:
Function function1(ByVal x as integer)
data1(1)=1
data1(2)=3
data1(3)=8
function1=data1(x)
end function

---

Cinzia

---

Sito RIO
Il mio Blog

Answer 2

Cinzia, to return a value in a function, You can use "Return"

Answer 3

I have a function.  The function has a return.
Sub sub1
y=function1(x)
End Sub

Function function1(ByVal x as integer)
data1(1)=1
data1(2)=3
data1(3)=8
Return data1(x)
end function

Why is it asking me for an end statement on the Return statement? And how will this work on a spreadsheet?

If it say end of statement expected, it is because there is an extra caractere on the line

as exemple, this will make this error

 "Return data1(x))"

There is a ")" at the end of the line that should not be there

Answer 4

Hi Crazypennie,
in VBA You can't use return in a function,  you always use FunctionName = result
http://msdn.microsoft.com/en-us/library/aa243374(VS.60).aspx

We are in a VBA forum so I supposed this was a VBA Function

---

Cinzia

---

Sito RIO
Il mio Blog