Questions with 2 workbooks
 

Hi all VBA experts:

I have two workbooks, Report.xls and RiskMatrix.xls. Whenever user
selects any of the NO option buttons on a UserForm in Report.xls,
certain data in the RiskMatrix.xls will be displayed on the combo box
of the UserForm in Report.xls. My question is:

1. Do I need to have both Report and RiskMatrix workbooks open at the
same time to perform such task?

2. My current code for data transfer to the combo box is this:
cmbConcernGrounds.RowSource = "RiskMatrix!$I$2:$I$3"

How can I program it in the new design?


Thanks in advance for your help!

Alex


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