Passing function as parameter of another function
Sub transliterate()
somecode
...
...
...
return word(a,b)
End Sub
sub word(x,y)
end sub
-
Does excel vba: Special Types - Functions as Arguments of Functions help?Andrew Morton– Andrew Morton2019-01-21 10:14:11 +00:00Commented Jan 21, 2019 at 10:14
-
What you're asking is not clear. Please use the edit link below the question to provide more information about what you're trying to ask.Cindy Meister– Cindy Meister2019-01-21 10:26:33 +00:00Commented Jan 21, 2019 at 10:26
-
Why would you not call a function direct from within another procedure/function?QHarr– QHarr2019-01-21 11:51:58 +00:00Commented Jan 21, 2019 at 11:51
-
Did I correctly understand your question, now?Cindy Meister– Cindy Meister2019-01-21 12:15:24 +00:00Commented Jan 21, 2019 at 12:15
-
i think yes but i am try to do something else, i am running it in Msword macrosakaamil– akaamil2019-01-21 12:23:26 +00:00Commented Jan 21, 2019 at 12:23
|
Show 2 more comments
1 Answer
VBA does not use return to pass back the result of a Function. VBA uses the following kind of construct, where the result is assigned to the function name. When End Function is reached the value assigned to the function's name is returned.
Sub testTransliterate()
Dim a As String, b As String, Result As String
a = "one"
b = "two"
Result = transliterate(x(a), b)
Debug.Print Result
End Sub
Function x(a As String) As String
x = a & " test"
End Function
Function transliterate(x, y) As String
Dim Result As String
Result = y & ", " & x
transliterate = Result
End Function