Hello,

I've been doing some searching and so far only found related posts for previous versions of VB .

Essentially all I am wanting to do is have a user form where you enter a reference number, hit enter and it searches an excel 2010 spreadsheet for that reference number.

If the reference number is found it returns the associated name which is in the cell in the column on the right. (e.g. ref = A1 & name = B1).

Thanks in advance,

Chris.