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?

Add the workbook name:
[MyBook.xls]Sheet1!H2:H6
"Mohan" wrote in message
...
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?

Hi Bob,

Thank you for your help.. it works..

"Bob Umlas" wrote:

Add the workbook name:
[MyBook.xls]Sheet1!H2:H6
"Mohan" wrote in message
...
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?