hi

i need to extract data off db.xls onto a combobox found on a form in wk.xls
both on the f drive of the same pc...
please help me with the rowsource syntax to extract data off the external
book's sheet1
regards

I think it is easier to use AddItem instead of RowSource, but others
may have a better idea. If you have both workbooks open, you can do
the following:

call ComboBox1.AddItem
(Workbooks("db.xls).sheets("Sheet1").Cells(?,?).va lue)
[repeat this as needed, changing only "Cells(?,?)"]

Hope this helps,
Dom



Zaahir wrote:
hi

i need to extract data off db.xls onto a combobox found on a form in wk.xls
both on the f drive of the same pc...
please help me with the rowsource syntax to extract data off the external
book's sheet1
regards