Private mTitleArray() As String
Public Property Get TitleArray() As String()
TitleArray = mTitleArray
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
Dim testArray(2) AS String
testArray(0) = "herein"
testArray(1) = "foo"
testArray(2) = "bar"
testTitleArray = testArray