The clipboard forgets!

[Ernesto]

I know very little about VBA, Alas
I have a VBA app which contains some call backs which repospond to msgs from
a server.
The call backs basically receive data and notifications and display them on
one the sheets.

If I understand the situation, ms-excel has its own clipboard.
Now the problem is when the callbacks come, upon updating of various other
sheets, the app clears its clipboard.
Is there a way to avoid this and keep the clipboard's contents?

This can be very annoying because the call backs can come unpredictably and
numerously, thus resulting in an essentially unworkable environment.

Any help will be most appreciated.

E

 

[Nick Hodge]

Ernesto

I suspect not short of pasting it somewhere

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Earl Kiosterud]

Ernesto,

I don't know if it's useful or not to think of Excel as having its own
clipboard. But this is important: If certain Excel objects (such as cells)
are placed on the clipboard, many operations will clear the clipboard,
unlike most other applications, where the clipboard retains its contents
indefinitely. You can see this just copying a cell, then entering something
into another cell and pressing Enter. But copy some text to the clipboard,
or a graphic, and it doesn't get cleared.

I don't think too many Excel programmers use copy and paste in Excel VBA, so
perhaps it can be avoided in your application if you're losing the clipboard
contents. This construction is often used:

Range("A1").Copy Destination:=range("A2")

This one will leave the clipboard clear too.