VLOOKUP in VBA to show information in a FORM

[tguitard]

Hello everyone,

I am very new to VBA and my writing may not look very advanced but I like to keep things simple :-)
I am very close to solving my problem but I just can't get there.

ContextI have a questionnaire and for each question, when the answer is no, a form opens. There is only 1 form for 100 questions so I have it set up so that the information input into the form each time the form is opened is linked to an error code (already assigned for each question). Therefore, when the form opens, there is a button to upload an error code which is then linked to the information they enter (which is entered into a number of text boxes). The information input is save to the "Summary of Results" tab.

If the user later goes back to a previously answered question and wants to make a change, the form opens and they have to click on a button that will say something like "upload original entry". The code below works. It pulls the error code into the TxtPreviousEntry text box.

Please Login or Register  to view this content.

The Call TextPreviousEntry_Change is meant to call the Vlookup that I can't get to work.

For the example below, the code is to have the Agent Name (TxtAgentName1 text box) show when they upload the error code.
This is not working.

Please Login or Register  to view this content.

Can anyone see an obvious error?

Any help would be greatly appreciated.

[mrice]

You appear to be using relative references, I suspect that you might need absolute references. Try removing the square brackets.

[tguitard]

[QUOTE=mrice;3615329]You appear to be using relative references, I suspect that you might need absolute references. Try removing the square brackets.[/QUOTE

Hello Martin,
Thank you so much for getting back to me.
Removing the square brackets did not work. It gives me the following error:
Runtime error 1004: Unable to find the Vlookup property of the Worksheet Function Class

?

[mrice]

Can you try just Application.Vlookup with the WorksheetFunction in the middle?