Need ComboBox Help

[collis47]

I'm new to VBA and I am having trouble with a combobox.

Im trying to get a list from an excel sheet come up in the combo box,
but the list is in another workbook.

ive named the list "Reps" and if i enter Reps into the RowSource
property I can get the list to appear in the combo box, but only when i
have the other workbook open and as the active sheet.

how do i make it so that even if the other workbook isnt open, and the
sheet where the list is isnt the active sheet, the list still appears?

Ive tried putting lines such as:

[Rental Plant Master.xls]Master!reps

and

[Rental Plant Master.xls]Master!P120

into the RowSource property but it comes up with an error and wont
allow it?

What do i need to do?

 

[Keith74]

Hi

Someone please correct me if i'm wrong here. As far as i know you are
going to have to open up the "Reps" workbook at some point. You can
using VBA open the workbook as a read only file, then either enter the
data you want into an array and set that as the rowsource for the
combobox and close the "Reps" workbook, or use the read only "Reps"
workbook directly as the rowsource.

HTH