Hi all

Please can somebody help me

[Excel 2010 on Windows 7]

I have a textbox that the user can populate by entering text and hitting
enter, creating several lines of text.
(Alternatively, she may take several lines of text from, say a webpage,
cutting and pasting it in)

Upon exiting the text box, I now would like to take each line, one at a
time, and place them into a globally dimensioned array called Features.

Private Sub TBoxFeatures_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim I As Integer
Dim LinesOfText As Integer
If Len(TBoxFeatures) 0 Then
LinesOfText = TBoxFeatures.LineCount
If LinesOfText 0 Then
For I = 0 To LinesOfText
Features(I) = TBoxFeatures 'XXX
Next I
End If
End If
End Sub

XXX = this is the tricky part - how to get *each row* of data into the
array - as it stands it places all lines together into each element of the
array


Thanks in advance

Peter Bircher