Userform searching data on another workbook

[sachs_v5]

Hi everyone,


I have created a userform to search data kept in a different workbook. Several problems in hand:

1) How to get the user form on file FKT.xls to retrieve data from the workbook Data1.xls?

2) Formating the presentation of data: the column M, where are the results i need to present on the user form are displayed on text line, i need them to be presented as vertical list.

3) to not be able to close the user form on the X, but using only the Close button, and display message "Please use Close button".

Thanks everyone,

VS