Click button to copy a character - using Class Module

This form has a number of buttons to represent Greek letter characters.
When clicked, it copies the character to the clipboard. It can then be pasted in Excel.
It uses a Class module as shown.

It worked fine in older versions of Excel but not with the current version. Instead of pasting the character, it pastes something unrecognizable (2 square boxes or 2 question marks).

FORM CODE (PARTIAL)

Please Login or Register  to view this content.

CLASS MODULE

Please Login or Register  to view this content.

This is/was a bug, although it shouldn't affect Office 2007 as stated in your profile.
An alternative is to use the Windows API.

https://www.thespreadsheetguru.com/b...-the-clipboard

Thanks, that pinpoints the issue.
I tried the following but get an error: Compile error, Variable not defined (for "Clipboard =")
This is with 2007.

Please Login or Register  to view this content.

Maybe try to assign text to a Select cell without Clipboard.

I need to have it in the clipboard though as this is much more flexible.

My apologies ByteMarks, I didn't follow through.
The code below is working on 2007.
Thanks for clearing this up.

Please Login or Register  to view this content.