VBA VLookup Help Please

[Spencer2005]

Hi
I’m hoping someone can help. I have a basic understanding of Excel but no knowledge of VBA.
I’m working on a school project where I have compiled a list of students and the course they are attending.
Worksheet 1 has a dropdown list containing student names in column D. When a name is selected, I want the adjacent cell in column E to populate with the course they are attending.
Worksheet 2 contains the student name in column A and the course name in column B.
I’m currently using VLookup to retrieve the info, but would prefer to use VBA. Can anyone help me with a code?
Thanks in advance!

 

[Spencer2005]

Yay! It works like a dream!

Thanks for sharing your knowledge and thanks even more for your patience..

 

[Fluff]

My pleasure & thanks for the feedback