VBA CopyText button

Hi, new here. I've had the best luck finding solutions on this site, but I can't seem to find one for this. Im' working a template and need to create a button that copies multiple text boxes from a user form into clipboard. I have an example here:

Sub CommandButton1_Click()

Dim MyData As New DataObject
MyData.SetText TextBox2.Text
MyData.PutInClipboard

End Sub

I know it's something easy I'm missing, can anyone help?!

I tried changing the command a little to included textbox.copy and just do a copy/paste without explicitly moving the text to the clipboard. But that just ended with more errors, and at one point just crashed everything. Lol, any ideas?

Yeah the clipboard is really unnecessary. I just need to copy the text from the UserForm to a service desk ticketing system. The goal is to copy about 8 textboxes all at once, then paste the combination to a web based form.

I tried adding a bit more to my textbox. I guess I'm trying to combine my original with:

Private Sub TextBox2_DblClick(ByVal Cancel As MSForms.ReturnBoolean)


Dim myClipbd As New DataObject


If TextBox2.Text <> "" Then
With myClipbd
.SetText TextBox2.Text
.PutInClipboard
End With

Else: MsgBox "There is no text to copy. To enter text,click this textbox once."


End If


End Sub

I'm not sure if I actually have to add a loop, something to scan all the textboxs and add them to a single clipboard.