title: how do i add multiple columns to a listbox using mixed data types in vba?
body: <p>I'm trying to add items (multiple columns) to a listbox. As I understand, in order to add multiple columns, you normally send them as strings like so:</p>
  
  <pre><code>Listbox.AddItem("column1;column2;column3")
  </code></pre>
  
  <p>This works for me just fine. But how do I add multiple columns when the item is not a string? I've tried things like:</p>
  
  <pre><code>Listbox.AddItem("name"; txtAge.Value)
  </code></pre>
  
  <p>and</p>
  
  <pre><code>Listbox.AddItem("name; txtAge.Value")
  </code></pre>
  
  <p>and even</p>
  
  <pre><code>Listbox.AddItem("name; Me![txtAge]")
  </code></pre>
  
  <p>None are working. I wasn't able to find anything on the web. What is the correct syntax?</p>