Detect user initiated copy

Question

I've adopted the Win API Clipboard work-around to the bug in the VB clipboard but after doing so realize that it's not really covering what I need.

What I really need is a way to detect if the user manually initiated a range copy [CTRL+C] prior to starting the macro procedure. Excel gives us the marching ants around the copied cell which is also the Active cell but so far I'm unable to discern any distinction in the cells Border properties indicating marching ants or otherwise.

A test of the WIN API clipboard might be helpful as a secondary workaround but detecting an active Excel copy-in-progress is preferred.

score 2 · Answer 1 · answered Oct 25 '15 at 05:06

2

Try this:

MsgBox Application.CutCopyMode = xlCopy

answered Oct 25 '15 at 05:06

Excel Hero

14,253
4
33
40

score -1 · Answer 2 · edited May 23 '17 at 11:44

-1

Thx Excel Hero, work's great.

Also tried the Application.CommandBars("Standard").Controls("&Undo").List(1) proposed solution in "Excel VBA How to detect if something was pasted in a Worksheet" but my Excel 2007 did not contain the List property. Given your simpler solution, I did not pursue troubleshooting the List issue.

Yes, but the Undo would likewise reveal a "Copy" string provided the List property were actually present.

edited May 23 '17 at 11:44

Community

1
1

answered Oct 25 '15 at 05:20

IronX

345
3
9

1

This only detects a paste, not the preferred active copy in progress. – Excel Hero Oct 25 '15 at 05:51

Detect user initiated copy

2 Answers2