Macro Error - "User-defined type not defined"

[Mstill]

I had this old macro that was used to copy the selected data into the clipboard as a text string separating the data in each cell with a comma.
Now I'm trying to add it again to Excel but I am getting this error.

Macro Error.PNG

Please Login or Register  to view this content.

Can anyone help with what the problem is?

Thank you.

[romperstomper]

You need a reference to the Microsoft Forms object library for that code to work. For a late bound version (no reference required) you can use:

Please Login or Register  to view this content.

though you should be aware that the DataObject is a bit buggy in current versions of Windows.

[Mstill]

Thank you for the reply.

I managed to restore an old version of my PERSONAL workbook and the original code is now working, but I'm not sure why

[TMS]

@Rory: why do you use this: GetObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")

What is the "thing" in curly brackets? Are there other similar references/things?

[romperstomper]

It's the CLSID. You can sometimes use that when the ProgID doesn't work (or you don't know it).