It seems that it is not possible to pass multiple string arguments to a
function in vba.
I am using vba in Excel 2000.
Why does this not work?
Dim testStr1
Dim testStr2
testStr1 = "hi"
testStr2 = "there"
' I get a compile error on the next statement
TestSub(testStr1, testStr2)
Sub TestSub(str1 as String, str2 as String)
MsgBox(str1 & str2)
End sub
Thanks,
Tijmen
Bookmarks