Here is a resource : https://www.mrexcel.com/board/thread...asting.889605/

It is possible. First, go to the VBA Editor. In the menu, click on Tools --> References, then put a check next to Microsoft Forms 2.0 Object library. Then paste this code:


( Untested here )
 
Sub PasteWOc()
Dim MyText As String

    Set MyData = New DataObject
    MyData.GetFromClipboard
    MyText = MyData.GetText

    If Left(MyText, 2) <> "WO" Then Exit Sub

    Sheets("wo").Range("a1") = MyText
 End Sub