I know I should remember this but I'm so rusty it isn't true and I've *got* to get this done tonight, so would someone please remind me - how do you get the contents of a multi-line text box in a userform to appear in the document with returns and not run together into one line?
The text in question is the address on a letter, so it has to remain on separate lines, but a straight find-replace of a keyword in the document with the textbox contents comes in with a couple of odd characters (empty boxes) instead of the return in each case and the text run together onto one line.
If somebody would please put me out of my misery I would be exceedingly grateful!
Rgards
Beryl M
Multi-line Text from Userforms
-
- NewLounger
- Posts: 15
- Joined: 28 Mar 2010, 20:45
- Location: Morden, Surrey (UK)
-
- Administrator
- Posts: 77254
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Multi-line Text from Userforms
If you use Selection.TypeText Me.TextBox1 or Selection.InsertAfter Me.TextBox1, it should work OK.
Regards,
Hans
Hans
-
- NewLounger
- Posts: 15
- Joined: 28 Mar 2010, 20:45
- Location: Morden, Surrey (UK)
Re: Multi-line Text from Userforms
Thank you, Hans, you've saved my life! (LOL - nothing much changes, does it?!)
Beryl M
Beryl M
BerylM