Excel UserForm entries into Word File/Form

[GalmOne]

Hello,

I've built a UserForm in Excel 2010 and I would like to build a Word 2010 form which is automatically populated by the entries of the Excel UserForm when one of the UserForm's command buttons is clicked. I've looked up basic tutorials on how to make a form in Word, but, otherwise I'm lost.

Please help,

Thanks!

[Leith Ross]

Hello GalmOne,

Apparently so is everyone else. You should post both the Excel workbook and the Word document. How else are we to know what you have done and want to do?

To Attach a File:
1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[GalmOne]

Alright, thanks. I uploaded both files in my original post. The Word document is supposed to go in the "Instructions" sheet of the accompanying excel file.

[snb]

I doubt whether you need so many comboboxes.
But if you do you can use easier methods to fill them; e.g.

Please Login or Register  to view this content.

To insert the Word document


Menu/ Insert/Object/create from file/ link

[GalmOne]

Thanks for that, it does shorten the code a good deal, I appreciate it.

I still need to figure out how to make the UserForm spit out a word document though.

[GalmOne]

Hello again, so I used the following code to update my list from a column in a sheet:

Please Login or Register  to view this content.

The problem is, if values are repeated in the column, they will repeat identically in the ComboBox list. Is there a way to remove these duplicates and (if possible) alphabetize the entries?