View Single Post
 
Old 09-18-2017, 02:49 PM
Farnkf1970 Farnkf1970 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Sep 2017
Posts: 1
Farnkf1970 is on a distinguished road
Default Copy excel userform data to a word template

Hello. I'm relatively new to vba and need some help. I have an excel user form that has a combobox and a number of text boxes, the combobox contains a list of course names. When the user clicks a course name in the combobox the text boxes are then populated by information that is relevant to this course such as cost of course, length of course and the tutor's name and contact number. What I want to do is put a command button on the form so that when the user choses a course in the combobox and all the relevant information is added to the text boxes the user then clicks the command button and this information is copied into a word template. I know how to add the command button and I am quiet happy creating the Word Template I just don't know how to code the command button to copy the data to the word template (I have created form fields in my word template). I am using office 2013 for Windows

Any help would be greatly appreciated.
Reply With Quote