Question

vba function当参数是数组应该怎么写

Public Function adress(ID As Integer, chengshi As String, keyarr() as )

End Function
如题，参数keyarr()是一个字符串类型数组，请问该怎么写呢 我直接写array报错

Answer 1

Public Function adress(ID As Integer, chengshi As String, keyarr() As String)

追问

fenshu = Array("90", "100", "110", "120", "130", "140")
k = adress(1, fneshu())'错误在这里
Function fneshu(id As Integer, fenshu() As String)
fneshu = Null
End Function
你好，我是这么写的，但是运行时提示错误：类型不匹配，请问这是怎么回事呢

fenshu = Array("90", "100", "110", "120", "130", "140")
k = adress(1, fneshu())'错误在这里
Function fneshu(id As Integer, fenshu() As String)
fneshu = Null
End Function
你好，我是这么写的，但是运行时提示错误：类型不匹配，请问这是怎么回事呢