Excel 2007 : Lookup Phone numbers

[revipod]

Hi guys, my first post on this website.
I need help making a list. My dad told me make a phone list, that when the person starts entering the name, the persons name comes up automatically. Like if I want to write
John Smith, and if Type Joh, the entire name John Smith comes up and I have to press enter for it to be accepted.
Also, I want to make it so that once the name is entered their phone number also gets written in the next column.
I'm sorry, I'm new to this so please make it as easy as possible.
If you have any questions just ask me!
Thanks!

[Paul]

Hi Revipod, welcome to the forum.

Is your dad also your teacher? Why would your dad care whether or not a worksheet with a list of names and phone numbers a) has a search field; and b) starts finding names as you type them?

To get you started, worksheet cells don't have KeyUp, KeyPress, KeyDown events like form fields do. So you could create a UserForm in Excel to do this. Once you start typing into the search field on the UserForm, you could have the Key event start scanning for matches on a worksheet, and pull in a corresponding value into another field on the form.

[revipod]

Thanks! No he's not a teacher and all he asked me was to make it so that once the person is entering their name the name autopops up, and once they enter it their phone number also appears.
How can I create the UserForm?