Sub
:Sub Hi_()
Dim HiStr As String
HiStr = "Hello World"
MsgBox HiStr
End Sub
Function
:Function Hi(TestHi As String) As String
' Input: this function receives a string as a parameter
' Output: returns a string
Hi = "Test Function with " & TestHi
End Function
Sub
来测试这个 Function
:Sub Test_Hi_Function()
Dim TstHiFunc As String
' send "Hello World" to Function Hi as a parameter
' TstHiFunc gets the returned string result
TstHiFunc = Hi("Hello World")
' for debug only
MsgBox TstHiFunc
End Sub
hi
,否则会出现错误提示。为什么要使用Function
?而不是普通的Sub
? - Shai Rado? hi()
(与Debug.Print hi()
相同)。 - Tim Williams