In the past, I've used a backhanded approach with
InputBox/SendKeys to quickly dump text to the clipboard. I'll share my trick with you if you promise not to tell anyone...
VB: AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when
copy/pasting, but IS if the keyword uses "quotes".
Sub TextCopy()
Application.SendKeys ("^c~")
InputBox "clipboard", ,
Sheets("Sheet1").TextBox1.Text
End Sub
Sure, it works with your textbox but it's also kinda neat to remember for dumping strings in general to the clipboard.