ListBox Column and Range setting

[Excelnoub]

Good day everyone,
I have a userform(Userform1) which has a Listbox(ListBox1). This listbox is linked to a sheet(Sheet1).

I want to make my ListBox1 show my information from Sheet1 from A3 to my last row of data.

I am stuck adding in the rowsource 'sheetname'!$A$3:$A$1000 but the 1000 is way to long.

I want, when I open my Userform1, that my listbox show the data from my Sheet1 in my column a starting from row 3 then looking at the last row of data.

Please help,

[Norie]

Clear out the RowSource and add this code to the userform module.

Please Login or Register  to view this content.

[Excelnoub]

Thank you so much