Populate listbox on userform from another workbook

[ipbr21054]

I have a userform which has a Listbox.
I would like to populate this Listbox with customers names another workbook.
The selected Listbox name would then be placed in Textbox1

Some info for you for the external workbox etc

Workbook is called DR
Worksheet in question is called POSTAGE
Customers names are in column B
The population wouldnt need to list ALL from column B but say last row & up 10 rows

 

[ipbr21054]

That worked.

Thanks very much

 

[ipbr21054]

@Engberg
Ive been using this for a good while now & like to ask you a question please.
The code at present populates a userform Combobox & the values are taken from worksheet DATABASE & sheet POSTAGE.
On the POSTAGE sheet is it possible for the code to only populate the Combobox with customers names that havent had a hyperlink applied to them ?

Basically some of the customers names will have been hyperlinked & some not, so at present the code takes the last 10 customers names & puts them in combobox list.
Later on the combobox selection will have a hyperlink applied to them.
So is it possible for the code to only get the names without hyperlinks.
Thanks

    With GetObject("C:\Users\Ian\Desktop\REMOTES ETC\DR\DR.xlsm") 'THIS POPULATES THE DROPDOWN FOR THE CUSTOMERS NAMES
        Set s = .Sheets("POSTAGE")
        Set b2 = s.Cells(s.Range("B" & s.UsedRange.Rows.Count + 1).End(xlUp).Row, "B")
        Set b1 = b2.Offset(-10, 0) 'THE MINUS VALUE IS HOW MANY NAMES TO BE SHOWN IN DROP DOWN LIST
        ComboBox1.List = s.Range(b1, b2).Value
       .Close 0
End With