Sample code: Private mTitleArray() As String Public Property Get TitleArray() As String() TitleArray = mTitleArray End Property This works in VBA but BASIC objects to the "as String()", but "as variant" is accepted.
Unfortunately, not all features in VBA could be ported to basic. Currently, the only way you can implement this kind of coding style is by converting it to basic's syntax. Also, I wasn't able to make this part of your code work : "Public Property Get" here's a suggestion on how to implement what you need : private testTitleArray() AS String Public Function getTitleArray() AS Array getTitleArray = testTitleArray End Function Sub Main Dim testArray(2) AS String testArray(0) = "herein" testArray(1) = "foo" testArray(2) = "bar" testTitleArray = testArray msgBox getTitleArray()(1) End Sub