title: Adding rows in a MultiColumn ListBox
body: <p>I'm messing around with VBA, especially with listboxes.</p>
  
  <p>I've created a search button, that's using a find property (.Find) and searches whatever we've put in the textbox in it's data table. </p>
  
  <p>It can add the search results to a listbox, but if we want the entire row from where search result is, how do we add it, instead of doing something like this <a href="https://stackoverflow.com/questions/11213962/vba-listbox-multicolumn-add">vba listbox multicolumn add</a>?<br>
  How can it be done, using VBA?<br>
  Is it even possible?<br>
  Else, is it possible without VBA?</p>
  
  <p><strong>What is happening:</strong></p>
  
  <pre><code>Data table: a | b | c | d | e
              1 | 2 | 3 | 4 | 5
  Search:   a 
  Listbox : a
  
  Search:   1 
  Listbox : 1
  
  Search:   2
  Listbox : 2
  
  Search:   d 
  Listbox : d
  </code></pre>
  
  <p><strong>What I "want":</strong></p>
  
  <pre><code>Data table: a | b | c | d | e
              1 | 2 | 3 | 4 | 5
  
  Search:  a
  Listbox: a | b | c | d | e
  
  Search:  1
  Listbox: 1 | 2 | 3 | 4 | 5
  
  Search:  2
  Listbox: 1 | 2 | 3 | 4 | 5
  
  Search:  d
  Listbox: a | b | c | d | e
  </code></pre>
  
  <p>If it's needed I can provide the code I am using for testing the search.</p>