listbox value to label's caption

[yinkajewole]

I have a listbox with multi column, using this code

 listbox1.value = label1.caption

the label only displays the text on the first column without the remaining columns.
for instance,
cat pillar
the label should display "catpillar"

 

[BlueAure]

Hi yikajewole,

You may need to loop through each index of the columns that you want to add. Try something similar to this:

numOfCols = 5

for i = 0 to numOfCols
listbox1.caption = listbox1.caption & listbox1.list(i,0)
next i

 

[Fluff]

If you're listbox is single select, try

Private Sub ListBox1_Click()
   With Me.ListBox1
      Me.Label1 = .List(.ListIndex, 0) & .List(.ListIndex, 1)
   End With
End Sub

 

[yinkajewole]

If you're listbox is single select, try

Private Sub ListBox1_Click()
   With Me.ListBox1
      Me.Label1 = .List(.ListIndex, 0) & .List(.ListIndex, 1)
   End With
End Sub

good one!

 

[Fluff]

You're welcome & thanks for the feedback