OrphanBear
04-27-2009, 12:41 PM
Hi,
Once a user double clicks on an item in my listbox, I would like a message box to appear with the value they clicked on. The problem is the value is not the bound column. I tried
me.listbox1.value
but that give the value of the bound column.
Private Sub UserForm_initialize()
Me.ListBox1.ColumnCount = 1
Me.ListBox1.BoundColumn = 2
Me.ListBox1.RowSource = "MyBound"
End Sub
Thanks for any help.
Once a user double clicks on an item in my listbox, I would like a message box to appear with the value they clicked on. The problem is the value is not the bound column. I tried
me.listbox1.value
but that give the value of the bound column.
Private Sub UserForm_initialize()
Me.ListBox1.ColumnCount = 1
Me.ListBox1.BoundColumn = 2
Me.ListBox1.RowSource = "MyBound"
End Sub
Thanks for any help.