Using Vlookup or something similar in VBA

Hi all,

I asked this question also on mrexcel.com but after a week of trying out i didn't find the right answer yet. Since i can't use attachments there im hopefull that this forum will guide me to the right answer.

See attachment;
When you place a "x" in column E under Production Returns the userform "Production Returns" opens.
On this is a label called "lblGelCodeR"
lblGelCodeR.caption displays a code like 0001.
It get it's data from column A on worksheet "Data".

On this forum is a link named "Info" that opens a new userform called "GelBMRProperties".
The link contains the following code;

Please Login or Register  to view this content.

When the userform "GelBMRProperties" opens the Gel code from the userform "Production Returns" displays on the userform "GelBMRProperties".

Also on this page is the label lblPagesReturn.

Now i try to do the following;
P
I would like that some Vlookup code looks to lblGelCodeR on GelBMRProperties and gets data from worksheet "Products" and changes lblPagesReturn on GelBMRProperties to the corresponding value.
The corresponding amount of pages is in column "E" of worksheet "Products".

See attachement

Thanks in advance.

Please Login or Register  to view this content.

Looks like I modified the wrong sub. I'll look at it again....

Thank you very much in advance


Saw i uploaded a file with password on it..

Edited it and it's without password now

Please Login or Register  to view this content.

'Productreturns form code

Please Login or Register  to view this content.