Copy elements from listbox

[EdwardJunior]

hi,
how do i select values from my listbox1 (after he gave me values ) copy and paste the value anywhere?

my listbox result have 3 cols

 

[DanteAmor]

Hi and welcome to MrExcel

For example, with a commanbutton:

Private Sub CommandButton1_Click()
  With ListBox1
    If .ListIndex = -1 Then
      MsgBox "Select a record"
      Exit Sub
    End If
    
    Range("A10") = .List(.ListIndex, 0)
    Range("B10") = .List(.ListIndex, 1)
    Range("C10") = .List(.ListIndex, 2)
  End With
End Sub