How can I pass a TextBox (more than 255 chars) into Word Template FormField???

[jdr360]

I have been stuck on this for a long time, I'm trying to pass Excel UserForm TextBox (of more than 255 chars), into a Word Template FormField, but not having any success. I keep getting the String Too Long error. I know Excel Strings can be more than 255 chars, but just not sure how to go about passing it to Word. The following is what I have so far:

Please Login or Register  to view this content.

Can someone shed some light on this? I have been stuck on this one for weeks now and have not found a solution.

[xlnitwit]

Hi,

That seems to be a long-standing problem- https://wordmvp.com/FAQs/MacrosVBA/S...mFldResult.htm

[jdr360]

Best solution I could come up with, is recreate the Word document in a new worksheet. Populate the appropriate cells and set the print range. Actually works better this way, don't get the delay of opening the word document and no issue with passing more than 255 chars.

So my next question is, how do I mark this Solved?