I have this code when the userform loads:

Private Sub UserForm_Activate()
' Read initial values from 4 rows after "My Range":
lCurrentRow = Range("My Range").Cells(4, 1).Row
LoadRow

I need to add listbox1 to this UserForm_Active sub.

I put a list box on the userform so that the user can select which
record to go to on the worksheet so they can edit the record through
the userform. I am not quite sure how to populate the data onto the
list box so the user can choose which record to go to.

I need the listbox to only be populated with data from column A
starting 4 rows after "My Range" through the next blank cell in column
A. Is there an easy way to do this and have the list box be more of a
drop down box?

Thanks in advance for any assistance.