当然可以
例:
在form上加个CommandButton就可以了
Private Sub Command1_Click()
Dim i As Integer
Dim a() As Integer
a = aaa
For i = 1 To 10
Debug.Print a(i)
Next i
End Sub
Private Function aaa() As Variant
Dim a(10) As Integer
Dim i As Integer
For i = 1 To 10
a(i) = i
Next i
aaa = a
End Function