Word userform

[bqheng]

Hi, I have this document that helps user populate information. Users will key in the same information on, for example, Row 1 columns 1 to 4. When they execute the command, the information will be populated into 2 rows in the document with additional trailing information. It is a must to have the same information in multiples of 4. Meaning columns 1 to 4 is one set of information, 5 to 8 can be another set of information. I'm trying to reduce the effort needed to repeat the information 3 more times for each set of information. Is there a way to key the information into 1 textbox and the same results can be achieved?

[macropod]

Why do you have the users re-keying the same info in columns 1-4? Surely you could design the userform so that each item need only be keyed once, then use the appropriate code behind the userform to replicate the data as & where needed.

[bqheng]

That's what I'm lacking, a code that can replicate the info without the user having to enter the same info 4 times

[macropod]

For that you could use code like:

Please Login or Register  to view this content.

[bqheng]

Thank you macropod. Now the information in 1 textbox can be replicated across 3 other textboxes. But I need it to replicate on the second row as well. Also, there are trailing information that needs to be added into each textbox. For example, user key in AB in textbox 1 and execute. the result on the word document should be AB-20ul RSID, AB-5ul RSID, AB-5ul PSA, AB-1ul PSA, and replicated in the second row. The trailing information is fixed

[macropod]

Try:

Please Login or Register  to view this content.