vLOOKUP in VBA

**Jakes** · 03-03-2011, 09:58 AM

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

**Jakes** · 03-03-2011, 10:01 AM

O dear, this is posted in the wrong forum! I apologize, Mods.

**jwright650** · 03-03-2011, 10:41 AM

Jakes, See if this is something that you can use.

Click the Command Button, Enter an ID# from the drop down menu.

**Jakes** · 03-03-2011, 04:03 PM

This is exactly what i was looking for! Thanks very much!
Now if I may ask - How do I add a Update command button, that update the customer information, say for instance the address has changed?