I'm trying to break a delimited string into an array using the Split function, then transfer the string array into another array.
Using the split function to break this down generates a Type Mismatch.
VB Code:
Choices = Mid$(QuestionArray(0).Question, InStr(QuestionArray(0).Question, ">") + 1, Len(QuestionArray(0).Question))
I don't understand where the type is mismatching. The result is a delimited String. I am using a : as the delimiter, those have always worked for me in the past. The only thing that comes to mind is that the entire formula I'm using must be of type String.




Reply With Quote