List box using cell values

Hi everyone,

I am trying to build an information userform. I have 5 colomns on a sheet that include data, which I am keeping the sheet hidden.

What I am looking to do is have the information that is in these cells to populate in list boxes on a user form, I have tried

.AddItem ("Sheet2").Range("A2")

I would like to do this as a loop though as there can be a mass range of information in the column.

Can anyone help?