Hi, I have a last small problem. I tried everything, but I can't nail it.

I have a closed external file. In this file I have two columns A and B. A contains names and B personal messages.

In the "internal" Excel 2003 file I have a multipage userform. On the second page I have a textbox that has to show the personal message on the basis of the name entered in the first page (textbox "Naam"). How do I do that? I think it's handy to put the code in the button on page 1 that navigates to page 2.

Dim ExtBk As Workbook
Dim ExtFile As String

ExtFile = "K:\Boodschap.xls"
Set ExtBk = Workbooks(Dir(ExtFile))

Message.Value = Application.VLookup(Naam.Value, ExtBk.Sheets("sheet1").Range("A1:B20"), 2, 0)