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?