OrphanBear
04-27-2009, 09:10 AM
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
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