vLOOKUP in VBA

Hi there, I am new here, and would like some help.( I am new to using VBA)

I have created a Userform in excell Visual basic, where I create new customers and place them in a database. Each customer have a ID, name, surname, address, etc, each.

Now I want to create a new form that retrieve (and update) some info that I have entered into that database. In exell the function is VLookup. Basically I want a Textbox1 where I enter a user ID, and the corresponding info in the database must show up in TextBox2 in the same UserForm. Is that possible, and if so, any example code perhaps?

Thanking you in advance,

Jakes


I am using Excell 2007