title: Userform listbox rowsource not populating
body: <p>I have a userform with an <code>OK</code> and <code>Cancel</code> button and a listbox. It is supposed to populate using this code:</p>
  
  <pre><code>Private Sub UserForm_Initialize()
  
  Me.StartUpPosition = 0
  Me.Top = Application.Top + (Application.Height / 2) - (Me.Height / 2)
  Me.Left = Application.Left + (Application.Width / 2) - (Me.Width / 2)
  
  With Me.ListBox1
      .RowSource = ""
      .ColumnCount = 7
      .ColumnWidths = "80;100;20;1;20;1;1000"
      .RowSource = Sheets("BOH Database").Range("H9:N14").Address
    '  .RowSource = Sheets("BOH Database").Range("H9:N" &amp; Sheets("BOH Database").Range("a65536").End(xlUp).Row - 1).Address
  End With
  
  End Sub
  </code></pre>
  
  <p>Neither RowSource statements work. I have tried clearing RowSource before filling it again. What am I doing wrong?</p>
  
  <p>EDIT:
  I've added the code i currently have here as it doesn't show properly in the comment:
  I'm using this code based on yours and it's crashing the sheet: </p>
  
  <pre><code>With Me.ListBox1
   .ColumnCount = 7
   .ColumnWidths = "80;100;20;1;20;1;1000"
   .RowSource = "'" &amp; Sheets("BOH Database").Name &amp; "'!" &amp; Sheets("BOH Database") _
      .Range("H9:N" &amp; Sheets("BOH Database").Range("a65536").End(xlUp).Row - 1).Address
  End With
  </code></pre>