hello
I have many textbox about 11 . I try copying for each textbox to specific column into listbox . for instance textbox1= ss then column 1 in listbox =ss and textbox2=bb then column2= bb and so on for each textbox should copy to next column based on arranged array .
this is what I have , but it gives error "couldn't set the lis property invalid property array index" in this line
ListBox1.List(ListBox1.ListCount - 1, L) = Application.Transpose(myArr)
Option Explicit
Dim myArr() As Variant
Private Sub CommandButton1_Click()
Dim L As Long
myArr = Array(TextBox1, TextBox2, TextBox3, TextBox4, TextBox5, TextBox6, TextBox7, TextBox8, TextBox9, TextBox10, TextBox11)
For L= 0 To 10
ListBox1.List(ListBox1.ListCount - 1, L) = Application.Transpose(myArr)
Next L
End Sub