windows - What does copy/paste actually do? Where is the copied information stored? - VBA -

I'm just wondering what's happening when you do something like this

  Range ("Test").  

Is any Windows that stores such information "global" copy / paste space? How can you reach it?

Copies of boundaries specified in the clipboard

You can easily verify it by duplicate a single text (an email, web browser, Excel spreadsheet, etc.) and then paste it into your second document. Are there.

You can access the clipboard from MSForms.DataObject class:

  as Dim DataObj Object Set up MSForms.DataObject Dim S As String DataObj = CreateObject ("MSForms.DataObject") DataObj.GetFromClipboard S = DataObj.GetText debug.print S  

work with Chip Pearson's site There are some other examples to do, manipulate, etc., with the clipboard.