I'm trying to copy a row from an excel file and paste it in my VB6 project in a Text2 as multiline but i have a hard time with it.
I'm trying this way:
If Text2 <> "" Then
MsgBox "Data already in Textbox"
If Selection.Rows.Count > 1 Then
varData = Join(Application.Transpose(Selection.Value), vbCr)
ElseIf Selection.Columns.Count > 1 Then
varData = Join(Application.Transpose(Application.Transpose(Selection.Value)), vbCr)
varData = Selection.Value
.Text = varData
But i have this run time error 91.
How can i fix this please?
Thanks again for your help