Export UserForm CheckBox data to Word-template

**ODeveloper** · 10-15-2015, 09:23 AM

Hello Gurus!

Is there any solution to populate CheckBoxes with Word files, and then export the data from Word files to a Word Template?

Here's an example how it should work:

CheckBoxtoMasterTemplateExample.jpg

You can find the example files from the attachment.

This userform already opens the MasterTemplate.dotx by clicking the "Export selected textfiles to MasterTemplate" -button.
CheckBoxes are not linked to Word files nor it will export any data from them to the MasterTemplate. Any solution?

Thx in advance!

-ODeveloper

CheckBox to MasterTemplate.zip

**ODeveloper** · 10-20-2015, 07:24 AM

Can someone help me with this? Or is it really too complicated to do it this way? Any other solutions?

-OD

**Norie** · 10-20-2015, 07:48 AM

The first thing I would do is change from multiple checkboxes to a multiselect listbox.

That will make things far easier when it comes to seeing which documents the user has selected to add to the template.

The attached file should show you what I mean.

**Norie** · 10-20-2015, 08:21 AM

Here's the code to add the text from the selected files to the template.

Please Login or Register  to view this content.

**ODeveloper** · 10-20-2015, 09:39 AM

Hey Norie,

Thx for the answers! In my case it's better that the checkboxes are separately. I have over 100 checkboxes and they are already grouped in different frames.

I tried your upload, but it didn't import the text files. MasterTemplate opened without selected textfiles data. Am I missing something here? Is there any possibility that you could implement that code to the original file I sent.

Thanks anyway!

-ODeveloper

**Norie** · 10-20-2015, 09:46 AM

There was no code in the uploaded file to add the data from the textfiles to the template, I justed post the code to do that in post #4.

As for multiple checkboxes, that sounds like a nightmare to me unless you have good naming convention going on.

**ODeveloper** · 10-21-2015, 02:34 AM

Hi again,

I opened the file you uploaded and found this from the Module1:

CaptureNorie.JPG

How can the code be there if you didnt put it there? :D

For me it would be much harder to put all the checkboxes to a listbox. There would then have to be several different listbox, and you couldnt see what you have chosen, unless you open them all separately. Now they're all in one big window which makes it much clearer to see what's chosen.

Maybe I'm missing something here(?) But the code still isn't working. First, there should be a code to link the checkboxes to the word files, right?

-OD

**ODeveloper** · 10-21-2015, 02:38 AM

Oh damn, sorry I'm not awake I guess... :D Got it!

Thx Norie!

**ODeveloper** · 10-21-2015, 02:49 AM

I would be very thankful if you could make the same code for the checkboxes instead of listbox.. I'm too newbie to figure out how it's done.

Thx,
ODeveloepr

**Norie** · 10-21-2015, 03:14 AM

How couldn't you see what was selected in the listbox(s)?

You don't 'open' listboxes, perhaps you are thinking if comboboxes?

As for linking checkboxes and Word files that's one of the things I can see being difficult when using checkboxes.

I'll see if I can come up with something using checkboxes instead of a listbox and post it later.

**ODeveloper** · 10-21-2015, 03:38 AM

I have some comboboxes which define the value for checkboxes (true/false). But in every case, the user have to be able to uncheck and check some of the checkboxes by hand.

Here's a small example where the value chosen to comboboxes have defined a pre-selection to checkboxes (sorry for the hard censoring):

Capture.JPG

The preselection would be more complicated to do to listbox I guess?

Or would there be an easier way to do all this?

**Norie** · 10-21-2015, 05:16 AM

Well since you seem to have some sort of hierarchical thing going on listboxes might not be appropriate, but I suppose you could look at using a treeview.

Do you have the 'hierarchy' stored somewhere?

**ODeveloper** · 10-21-2015, 05:25 AM

Treeview sounds interesting.

The 'hierarchy' exists already, but so far I only have a part of it in my head. I'm working on "visualising" it at the moment..

Export UserForm CheckBox data to Word-template

LinkBack

Thread Tools

Rate This Thread

Display

Export UserForm CheckBox data to Word-template

Re: Export UserForm CheckBox data to Word-template

Re: Export UserForm CheckBox data to Word-template

Re: Export UserForm CheckBox data to Word-template

Re: Export UserForm CheckBox data to Word-template

Re: Export UserForm CheckBox data to Word-template

Re: Export UserForm CheckBox data to Word-template

Re: Export UserForm CheckBox data to Word-template

Re: Export UserForm CheckBox data to Word-template

Re: Export UserForm CheckBox data to Word-template

Re: Export UserForm CheckBox data to Word-template

Re: Export UserForm CheckBox data to Word-template

Re: Export UserForm CheckBox data to Word-template

Thread Information

Users Browsing this Thread

Similar Threads

Send Data From Excel Userform to Microsoft Word Document Template

Excel userform to Word template letter with bookmarks

[SOLVED] Send UserForm CheckBox Value to MS Word

Export from Excel to a Word Template

Export data to a word template

Export UserForm Image for use in Microsoft Word

[SOLVED] export excel data to a word template using a macro

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions