PDA

View Full Version : Help W/Small Code . .



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

Bob Phillips
04-27-2009, 09:34 AM
Change ColumnCount to 1

mikerickson
04-27-2009, 10:18 AM
Set the .ColumnWidth property to ";0"

OrphanBear
04-27-2009, 12:24 PM
Thank you XLD - That worked perfect..