Help W/Small Code . .

[OrphanBear]

Hi all,

I have a listbox is a userform. How can recode the below code so that the bound column does not show in the listbox? Column 2 is the bound column, but I only want column 1 to show . . .thanks,

Private Sub UserForm_initialize()
Me.ListBox1.ColumnCount = 2
Me.ListBox1.BoundColumn = 2
 
Me.ListBox1.RowSource = "MyBound"
End Sub

[Bob Phillips]

Change ColumnCount to 1

[mikerickson]

Set the .ColumnWidth property to ";0"

[OrphanBear]

Thank you XLD - That worked perfect..