Can this be done

[igessey]

I would like to know if there is some way to flash a pop up message box based on clipboard contents.

For example, if the clipboard contained a 4 digit number (copied and pasted from another application) then it would display a message box saying "Blah blah".

The clipboard would need to then clear itself and be ready for the next input.

Is this just fanciful thinking or can it be done?

 

[Golom]

Try something like

Public Sub PopFromClipboard()
    Dim strClip As Variant
    strClip = Clipboard.GetText
    If Len(strClip) = 4 And IsNumeric(strClip) Then
        MsgBox "Clipboard contains " & strClip
    End If
    Clipboard.Clear
End Sub

 

[igessey]

Great

I will give that try - see what happens

Thanks

Ian