Create 1 text from multiple textbox/checkbox in userform?

jpweraser

New member
Joined
Jun 30, 2015
Messages
1
Reaction score
0
Points
0
Hello all, new to the forum. I am working on a userform to make my job easier. I have created a userform with all of the fields that I need to input. The goal is to be able to quickly input the necessary data and click the "Generate" button and either:

1. Combine all of the entries and display 1 text in the large textbox to the right with no extra spacing/formatting abnormalities.


OR

2. Export all of the entries to a .txt or .docx file with no extra spacing/formatting abnormalities.
Example:

Greet: Name/Branding: Y. Reflect Question: Y. Relate/Emphasis: N/A. Take Ownership: Y. Set The Agenda: Y. Greet Notes: …


Also, if possible, can the checkbox items be converted to true=Y and false=N and then be exported as such?
I have searched all around the internet and found several codes to try but none of them have been the right solution for my goal. Thank you very much in advance for your help!
 

Attachments

  • Doc Assistant.xlsm
    31.3 KB · Views: 21
Back
Top