I found the following code in MrExcel posted by DK and I quote:
"You can use the DataObject provided by the MS Forms library. For example, say you have a textbox called TextBox1 and a command button named cmdCopy this code will copy the contents of the textbox to the clipboard."
Private Sub cmdCopy_Click()
Dim YourDataObject As DataObject
If Me.TextBox1.Text <> "" Then
Set YourDataObject = New DataObject
Yet another element to add to my growing list of things to learn. Once the form is hidden then you can paste the result manually wherever you wish.