What I ultimately need to do is copy the text from a textbox to the clipboard. I posted earlier and Skip had recommended that I just copy the contents of the textbox into a cell and then copy the cell, which will put it on the clipboard. This kind of works (thanks skip) however if my text in the textbox has line returns in it, it automatically puts quotes around the text when i paste it.
Example:
This is one line.
pastes as:
This is one line.
Example
This is two lines.
Yes it is.
pastes as:
"This is two lines.
Yes it is."
Hopefully that makes sense. Does anyone know how to avoid this? So that even if it contains line returns it pastes without the quotes?
Example:
This is one line.
pastes as:
This is one line.
Example
This is two lines.
Yes it is.
pastes as:
"This is two lines.
Yes it is."
Hopefully that makes sense. Does anyone know how to avoid this? So that even if it contains line returns it pastes without the quotes?