title: How can I allow for the entering of multiple lines of input into a VBA InputBox?
body: <p>I'm working on a macro that would allow me to type (or more likely, to paste) a SQL query into an <code>InputBox</code> and upon clicking "OK", it returns the results of the query against the database. The problem is, by default VBA only accepts one line of text and SQL code is written in a more structured, multi-line format for readability. When I try to paste SQL code into the <code>InputBox</code>, all but the first line of text are truncated. My next idea is to read the contents of the clipboard and replace any newline characters with a space before displaying the InputBox and prompting me to enter a query, but obviously that wouldn't help with queries which I am typing in rather than pasting. Any help would be greatly appreciated!</p>