asked on
Dim rngName As Range
Dim ws As Worksheet
Dim i As Integer
Set ws = Worksheets("Equipment")
For i = 1 To ws.Cells(ws.Rows.Count, 1).End(xlUp).Row Step 1
If ws.Cells(i, 1).Value <> vbNullString Then Me.ListBox2.AddItem ws.Cells(i, 1).Value
Next i