I would like to write a macro that makes a small window pop-up (similar to an InputBox) that requests the user inputs a fair amount of text (a paragraph, or more) and allows multiple lines. This is then exported to a certain cell.
An InputBox only allows one single line of text. Is there some other type like this that would allow the user to type his text in? Similar actually to the text input box I'm using on this website. I can type lots of stuff, and start new lines if I like.
After that, once I have the information I'd like to be able to export this to a predefined cell. This is going to be for a report that users fill-in.
I can code the text exporting, I think, but could you please suggest how I'd make the text input stuff?
Thanks for any help!