Vlookup in sub not displaying any data

Good Morning Fellas,

I am very new here and I have been self teaching myself through the use of this forum and though you guys might be able to help. This is my first forray into VBA so what I have is probaby not the most efficient way to go about things but here goes.

Basically I made a multipage userform to input data into a spreadsheet. I want to use a vlookup to put a value into a cell based on a selection made in the userform. I need to do this for 4 different selections made in my userform. I am not sure how to implement the vlookup in VBA. I was successful when I did it as a function in excel, but I cannot seem to make it work right here. I have searched extensively for help with this but I couldnt quite manage to find something applicable.

Here is the code:

Please Login or Register  to view this content.

Be gentle guys...

Thank you all very much for the help I really do appreciate it

Basically what I need some guidance on is how do I incorporate that VLOOKUP and then apply it to cells (r,5) (r,8) (r,10) and (r,11). Thanks again for any help!