VLookup In UserForm

Hi Guys,

I am undertaking my first Userform set-up after following several templates/guides available on the web, however I think I have jumped in the deep-end by creating such a big project.

I have completed the form design, named all list/boxes etc and have done the majority of coding (at least I think so far). I am know having trouble getting some sort of VLookup to work within the Userform having tried various different codes.

I have attached a slimmed down version of my project and would like the following

cboReg - This it linked to a named range (column A4 down)
txtMake - I would like this to be pulled through from cboReg selection (Make is in column B)

If someone could get me started I will be able to transpose to the rest.

If you spot any inherent errors please point them out, also I am planning on hiding all the sheets so users can only use this UserForm (I have some code for this already) if this has any bearing on any codes.

Thanks in advance

Stuart