VLOOKUP in userform

**Hond70** · 10-24-2011, 12:45 PM

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.

Please Login or Register  to view this content.

**royUK** · 10-24-2011, 01:14 PM

Why do you need VBA, VLOOKUP works across workbooks

**Hond70** · 10-25-2011, 04:46 AM

I need VBA because I use a userform. This is managed by VBA.

**royUK** · 10-25-2011, 07:32 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!