Thanks ranman256
Private infoArr() As String
Private bookMarks() As String
Now work through out the form which is great.
I can’t however populate infoArr()/StringsArr() using the FillVars(xx, StringsArr(),xx) input. To fix this I added:
Call inputOneForOne2DArrays(StringsArr, infoArr)
To the FillVars(code) and it calls this:
Function inputOneForOne2DArrays(orignalArr() As String, targetArr() As String)
Dim xCo, yCo, xSize, ySize As Integer
xSize = UBound(orignalArr, 1)
ySize = UBound(orignalArr, 2)
ReDim targetArr(xSize, ySize)
For xCo = 0 To xSize
For yCo = 0 To ySize
targetArr(xCo, yCo) = orignalArr(xCo, yCo)
Next yCo
Next xCo
End Function
It would be nice to know a method of passing an array from a module to a form to use privately using only the module call. (I guess the point of private variables is that they can’t be picked up by any piece of code.)
gmaxey
It is because the ComboBox did not contain the information that was populating the bookmarks. Each option contained three parts, one for the selection list and two for populating the bookmarks. The combobox would display StringsArr(i, 0), and selecting ‘i’ would populate the bookmarks with StringsArr(i, 1) and StringsArr(i, 2).
This means that the combobox could be used for passing bookMarks() but not StringsArr()/infoArr(), which are both needed.
Thanks for the help guys.