• Only just noticed that my previous method of getting/setting the clipboard has broken in windows 10 so I've written a quick class for clipboard management.


    Class Code (I called my class "ClipBoard"):


    Example usage in a vba module:


    Also attached the class as a text file which preserves whitespace (you'll have to rename from ClipBoard.txt to ClipBoard.cls) and can be imported into VBA


    hth


    Reference: https://docs.microsoft.com/en-…ormation-to-the-clipboard