title: How to get selected value in multicolumn listbox
body: <p>I have a multicolumn listbox in my userform and I would like to get all the values of the elements which are in the selected row in the listbox.<br><br>Here is my userform:<a href="https://i.stack.imgur.com/o4STx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/o4STx.png" alt="UserForm with ListBox"></a> </p>
  
  <p><br>
  Just like in the photo, I want to select one line then I will click button <code>Associer</code> and I could get the information of this row. I can just get the first column which is <code>CAN20168301436</code> I want to get the information from the whole line.<br> How can I do it? <br/>Here is my button clicked event: <br></p>
  
  <pre><code>Private Sub CommandButton3_Click()
     a = ListBoxResultatFind.Text
  End Sub
  </code></pre>