Re: Excel 2007 VB function call return value syntax question

This did not work either:

Yes it does.

Exit Function

You don't need this, not that it does any harm.
--
Jim
"pop tufty" <poptufty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0ABA2AE0-D3B4-4026-891D-7EC90FB10081@xxxxxxxxxxxxxxxx
office 2007, excel, XP, dell laptop

Of course when I upgraded to office 2007, I have to port my macros.
I am getting a syntax error on this function and do not know why.
Help button is not much use.

Function Get_Value()
Dim Value As Integer
Value = 10
Return Value ' <-- syntax error shows here
End Function

How is one supposed to return a value from a function?

This did not work either:
Function Get_Value() As Integer
Get_Value = 10
Exit Function
End Function


Thanks - Pop Tufty




.