Filling a combo box from another workbook

[aharris2693]

Is it possible to fill a combo Box that is on a userForm in one workbook with a range from another workbook. Thanks

 

[aharris2693]

To be a little more specific, I have the two workbooks in the came directory. I have tried to map the entire path and it still gives me an error. However if the workbook with the source is open, it works fine. Do I hve to open this other workbook just to fill this box? My code currently looks like the following:

cmbNames.Clear
For Each i In Range ("'F:\DATA\USERS\HarrisAL\Mitch\[Wilmington_Seating_Chart.xls]Chart'!D2&quot
cmbNames.AddItem (i)
Next

Thanks Again

 

[aharris2693]

If it helps any, the error is 1004 Method 'Range' of Object '_Global' failed