Choose multiple Word-Documents via UserForm TextBox and combine them to Master Word-Doc

Hi Greg,

Sorry for the confusing explanation. I should have deleted those comboboxes from the userform. The idea is that the combobox values defines which checkboxes gets value = True.

For example, If I choose these alternatives from the comboboxes:

EFexample1.JPG

Then these checkboxes gets value = True:

EFexample.JPG

This would just be a "pre-selection" and then you should be able to add more selections manually to comboboxes just by clicking them.
However, I think I know how to do it with "Case" code, and that's not the issue. Sorry for being actually quite confusing with that :D

So don't care about the comboboxes, I'm just intrested about how can I link those specific word-documents to specific checkboxes

Example:

CheckBoxMale should be linked to GenderMale.docx
CheckBoxFemale should be linked to GenderFemale.docx

CheckBoxGreen should be linked to ColorGreen.docx
CheckBoxBlue should be linked to ColorBlue.docx
.... and so on.

All the data from the selected word-documents (= selected checkboxes) should then be exported to ExistingTemplate.docx

Hope this made it a bit clearer?

Thanks for you interest!

-ODeveloper


PS. I'm sorry but I also misspelled the TITLE OF THIS THREAD lol. It should say

Choose multiple Word-Documents via UserForm CHECKBOX and combine them to Master Word-Do

sorry!

Just curious, why is the userform in Excel instead of Word?

Userforms in Word are almost identical to those in Excel.

The major difference, I suppose, is in Excel you can take data from the workbook to populate the controls, as you are currently doing.

If you wanted to move everything to Word you would have to hard-code the data for the form.

You could actually import the existing Excel userform into a Word document.

See the updated template document.

Hi again,

Take a look at the attached workbook and see what you think.

I've used OptionButtons instead of CheckBoxes to ensure that multiple selections (e.g. both Male and Female) cannot be made.

I've concentrated on totally decoupling the UserForm from everything else in the workbook. (This means that the UserForm can be placed in a workbook that contains nothing else, and will still compile successfully.)

A calling routine ("ShowForm") displays the UserForm, retrieves the values entered for Name, Gender, Colour and Category, and then passes them as arguments to the "ExportUserFormDataToWord" routine where they can be used in Search & Replace operations etc.

It's worth noting that the ONLY place where these values are defined is in the captions of the OptionButtons on the UserForm - i.e. if you want to change Blue to Purple and Category A to African Antelope, the only place where you need to make these changes is in the Captions of the appropriate OptionButtons. This makes the UserForm that much more flexible and re-useable.

I'm not exactly sure how you want to import the Gender, Colour and Category documents into your Master Template, but at least the ExportUserFormDataToWord routine now "knows" the values associated with the required documents.

Hope this helps - please let me know how you get on, and feel free to ask if there's anything you need me to explain.

Regards,

Greg M



P. S.

Regarding Norie's Post #7:

The major difference I suppose is in Excel you can take data from the workbook to populate the controls, as you are currently doing.

If you wanted to move everything to Word you would have to hard-code the data for the form.

Norie makes a valid point. The UserForm in my workbook could be imported into Word and the data are already "hard-coded" in the captions of the OptionButtons.