To set what columns are visible:
click on the listbox, and go to the column width in the properties. Set the width for width for the first column(when i made my table for loading I put the column I wanted to see when form was loaded in the first column)to what value it takes to show the column. In my case it was 100pt.
Enter values for all the columns. For any column that you don't want to see use 0pt.
Below is the code I used to for the form.
Private Sub CommandButton1_Click()
Unload UserForm2
UserForm2.Hide
''''Enter Listing Agent
Worksheets("TEMPDB"

.Range("K3"

.Value = ListBox1.List(ListBox1.ListIndex, 0)
Worksheets("form"

.Range("d4"

.Value = ListBox1.List(ListBox1.ListIndex, 0)
''''Enter Listing Agent ID
Worksheets("TEMPDB"

.Range("E3"

.Value = ListBox1.List(ListBox1.ListIndex, 1)
'''enter split percentage
Worksheets("FORM"

.Range("E4"

.Value = ListBox1.List(ListBox1.ListIndex, 2)
Worksheets("work"

.Range("c40"

.Value = ListBox1.List(ListBox1.ListIndex, 2)
'''enter TEAM INFORMATION
Worksheets("TEMPDB"

.Range("AJ3"

.Value = ListBox1.List(ListBox1.ListIndex, 3)
Load UserForm3
UserForm3.Show
End Sub
Private Sub CommandButton2_Click()
Unload UserForm2
UserForm2.Hide
sheets("CONTROLS"

.Select
Range("D12"

.Select
End Sub
Private Sub ListBox1_Click()
End Sub
Private Sub UserForm_Click()
End Sub
Private Sub UserForm_Initialize()
sheets("work"

.Select
ListBox1.ColumnCount = 3
ListBox1.RowSource = "a4

23"
End Sub
I hope this helps. Let me know if you have any questions