Hi

i have a userform with two listboxes in them, i have set the columns in the listbox to 9 and would like to populate the column headers in the listboxes with the column header of one of the sheets 
Range("B3:J3")[
on of my other sheets have the same column headers, but i'd like for the listbox to take the data from a specific sheet so that when i change any of the column headers in that sheet, it will change in the listbox as well next time the userform is opened.

i have tried : 
With Me.ListBox1
.RowSource = Range("B3:J3").Address
End With
,but this gives an error, and this is where the scope of my know how ends too

Any help with this will be greatly appreciated.