title: VBA Excel Populate ListBox with multiple columns
body: <p>This may be a cheap question for some but I'm totally confused on how to populate my listbox. </p>
  
  <p><a href="https://i.stack.imgur.com/GdvKI.png" rel="noreferrer"><img src="https://i.stack.imgur.com/GdvKI.png" alt="form with listbox"></a></p>
  
  <p>Using this line I can populate the listbox as shown below:<br>
      <code>ListBox1.List = Sheets("Sheet1").Cells(1, 1).CurrentRegion.Value</code>
  <br>or<br></p>
  
  <pre><code>Dim rngName As Range
  Dim ws As Worksheet
  Dim i As Integer
  Set ws = Worksheets("Sheet1")
      For i = 1 To ws.Cells(ws.Rows.Count, 1).End(xlUp).Row Step 1
          If ws.Cells(i, 1).Value &lt;&gt; vbNullString Then Me.ListBox1.AddItem 
          ws.Cells(i, 1).Value
  Next i
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/XwLLT.png" rel="noreferrer"><img src="https://i.stack.imgur.com/XwLLT.png" alt="form with listbox 1 column output"></a></p>
  
  <p>Below is the data I'm planning to use to populate the list box and is progressive. Only the column has the fix count. <br>
  <a href="https://i.stack.imgur.com/kHzFq.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/kHzFq.jpg" alt="Data"></a><br><br></p>
  
  <p>Someone please enlighten me on how to populate a list box adapative to multiple columns and rows using <strong>FOR LOOP</strong> as shown in my code above. Any help appreciated. Thanks.</p>