Hello, I am trying to create a general template for resumes for a recruiting firm I work for, but I am having trouble! I am trying to create some sort of drop down box (I know this means VB/VBA) that will fill in info in other fields of the resume, e.g. entering the recruiters name will fill in the extension and email field. It would also be nice to type in a few letters and get a similar name to pop up. Anyway, ANY help is greatly appreciated. Thanks so much!

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic