Rowsource Property

[Guest]

Hi

I have a combo box on a user form and the list is populated from an excel
file. I have set the rowsource property to =sheet1!h2:h6. (the workbook name
= Account.xls). This works fine when the Account.xls is the active workbook.

How can I populate a combo box with values from a hidden workbook. (i.e.:
If the Account.xls workbook is hidden, I don't get any values to the combo
box) I tried to define a range and tried it, still doesn't work!! (i.e.: I
define the input rang eof shee1!h2:h6 as rngInput and specified '=rngInput'
in the rowsource porperty of the combo box.. still doesn't work!!)

Anyone has any idea?

 

[Bob Umlas]

Add the workbook name:
[MyBook.xls]Sheet1!H2:H6

 

[Guest]

Hi Bob,

Thank you for your help.. it works..

Add the workbook name:
[MyBook.xls]Sheet1!H2:H6

Hi

I have a combo box on a user form and the list is populated from an excel
file. I have set the rowsource property to =sheet1!h2:h6. (the workbook name
= Account.xls). This works fine when the Account.xls is the active workbook.

How can I populate a combo box with values from a hidden workbook. (i.e.:
If the Account.xls workbook is hidden, I don't get any values to the combo
box) I tried to define a range and tried it, still doesn't work!! (i.e.: I
define the input rang eof shee1!h2:h6 as rngInput and specified '=rngInput'
in the rowsource porperty of the combo box.. still doesn't work!!)

Anyone has any idea?