Assuming the workbook is open.

'[workbookname.xls]Sheet1'!A1:B200

--
Regards,
Tom Ogilvy


"skip " wrote in message
...
i need a userform listbox with a rowsource that can view a list in
another worksheet or workbook.

also a dropdown list on the userform to change the rowsource and view a
different list on a different workbook

i am getting close but not close enough to make it work


---
Message posted from http://www.ExcelForum.com/