> I want the row info to appear in the box in column format.

You want the data from a horizontal range in the worksheet to populate a
single column? Try AddItem in the Initialize event of the form, eg:

Private Sub UserForm_Initialize()
ListBox1.AddItem Range("Sheet1!D2")
ListBox1.AddItem Range("Sheet1!E2")
ListBox1.AddItem Range("Sheet1!F2")
ListBox1.AddItem Range("Sheet1!G2")
End Sub

HTH,
Andy