Share the Clipboard with VBA and the Windows API

Accessing the clipboard in Windows becomes quite tricky in VBA, particularly if you have to stay 32 and 64 bits compatible.

Here’s my compilation of portable routines, inspired by MSDN, Internet scraping and good sense.

First the Declares section (I know, it pours out of the frame on the right, just select and copy the text):

Then the VBA code:

Update: just a quick sample (Access VBA):

There’s an Access 2016 demo database (on devinfo.net), open it, go to the VBA editor (ALT+F11), go to the debug Windows (CTRL+G), type “Test” (without the quotes of course) and hit ENTER; any text in the clipboard will be displayed in the debug window.

Enjoy.