Warning: type should be explicit

[Cableguy]

I have 3 returns in a sub, that return a string...
Its my knowleage that we don't need to declare the return type for it to work as intented...

Return "Continue"

but, just to clarify, how would I declare the return type?

 

[stevel05]

Just append As Type to the subroutine name:

Sub mysub(Text As String) As String

Dim Result As String

.
.
.
Return Result

End Sub

 

[Cableguy]

Just append As Type to the subroutine name:

Sub mysub(Text As String) As String

Dim Result As String

.
.
.
Return Result

End Sub

thanks... actually appending the "as String" to the sub name did it, no need to dim the result inside the sub

 

[stevel05]

Yes it would, but I just put it there for completeness.