I just want to ask how to pass an array into a procedure:
Dim strText() As String
For i = 0 To FIELD_NUM - 1
strText(i) = Text(i).Text ' Text(i).Text is the text box in the form
loadOptionCatalogs (strText) <------------Typ mismatched occurs
Sub loadOptionCatalogs(strText() As String)
Could anyone tell me the correct method and give some explanation ?