HELP: Macros Vs InputBox

[Clinton M James]

Hey guys,

Need help, if it is possible.

What I want to do is have an inputbox that is more than one line so somebody
can copy and paste several lines of text from another application to a
document.

I understand the normal way is to do x = inputbox("Please enter your text
here") but is there a variant that will allow it to come up with a bigger
box for several lines of input?

Also I made a macro to find commas, and when it found one it would treat it
as a new line when displaying an address. I used Chr(10) to create the new
lines, except in my document it does not put a new line, rather a box and
keeps all text on the on line. Is there a way to fix this?

Thank you so much in advance if help is possible.

 

[Doug Robbins - Word MVP]

For the first item, see the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

For the second, you should use vbCr

Or, if you are using Edit>Replace, replace the commas with ^l
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP