Hi everyone,



New to VB not looking necessarily for someone to do this for me just if there's a term or something so that I can better search Google for how to do this.

Basically I have a standard Word file with a lot of docvariable fields, and then a userform where users enter text into the fields, and when hitting Ok it populates that into the Word document which is easy.

I'm trying to figure out how to do an if statement I think it is. So on the word document there's a heading "Sales rep" and it has 3 docvariables on 3 rows (I'd do it on 1 if it's possible to have a variable be formatted to be multiple lines). So basically the first line the variable name is "Full Name" second line and variable is "Phone Number" and 3rd line and variable is "Email address".

What I want is on the userform, a drop down that has a listing of 5 sales reps names. If the user clicks John Smith on the drop down and Saves the form, it then fills in John Smith, his number and his email. If they select a different user, it does the same with their info.

I'm sure this is pretty straight forward I just wanted to find out if this was called anything in particular so I know what to search for in learning how to do this? Thanks!!!