hello i found this code in this site that nearly answer my problem in excel vba coding, but when i ran it, it display only the first column.. how can i include the other column like column B, C and so on.... Thank you.
Private Sub CommandButton1_Click()
ListBox1.Clear
Dim i As Long
For i = Cells(Rows.Count, "A").End(xlUp).Row To 1 Step -1
ListBox1.AddItem Cells(i, 1)
Next
End Sub
Private Sub CommandButton1_Click()
ListBox1.Clear
Dim i As Long
For i = Cells(Rows.Count, "A").End(xlUp).Row To 1 Step -1
ListBox1.AddItem Cells(i, 1)
Next
End Sub
