Hi All,



I would appreciate some help with the following:



1. I have a user form with two list boxes.

2. The first list box displays the name of all open excel workbooks.

3. The second list box will display the sheets of the workbook the user
selects

from the first list box.

4. I would like to add an import button to my user form.

5. The import button will import the data from the workbook selected in

the first list box and from the sheet selected in the second list box into

sheet1 of the template workbook where the user form is displayed.



All comments and suggestion welcome.



Thanks,



Steve



PS I am using excel 2002 and windows XP.