Paste and keep source formatting

[HTSCF Fareha]

Trying to fathom out how to paste from clipboard (contains Excel data) into a textbox in word using VBA, whilst using the word option of "keeping the source formatting".

Dim Clipboard As MSForms.DataObject
    Set Clipboard = New MSForms.DataObject
    Dim myDataObject As DataObject
    
    Set myDataObject = New DataObject
    myDataObject.GetFromClipboard


Clipboard.GetFromClipboard
        
        TextBox3.PasteSpecial Paste:=xlPasteValuesAndNumberFormats

Many thanks!