副本上的 VBA 事件触发器？

VBA 中是否有一种方法，当我在 Excel 中复制单元格的值时，它会触发我的函数？

或者有什么解决方法吗？

或者我可以阅读按键并听 Ctrl+C 吗？

或者VBA可以读取复制文本的内容吗？

原因是：我将一些条目从 Excel 工作表复制到另一个程序，并且我想自动向已复制的所有条目添加灰色字体颜色。

为您的宏指定快捷键。

例如，如果您的宏是这样的：

Sub CopyAndMarkAsCopied()
    Dim r As Range
    Set r = Selection
    With r
        .Copy
        .Font.Color = RGB(100, 100, 100) 'dark grey font
        .Interior.Color = RGB(200, 200, 200) 'light gray background
        'whatever else
    End With
End Sub

In Excel 2010, view macros in Developer > Macros (or keyboard shortcut Alt-F8). In earlier versions of Excel, the menus are a bit different, but the keyboard shortcut works the same.

Select your macro in the list, and click Options.... In this dialog, you can assign a shortcut key to your macro. It can either be:

• Ctrl-some letter, in which case you have to type a lowercase letter; or
• Shift-Ctrl-some letter; type an uppercase letter.

In this example I chose Ctrl-Shift-C (note the uppercase C in the screenshot below).

I probably wouldn't mask default keyboard shortcuts that I normally use, like Ctrl-C, but you're free to do so if that's your thing.

Example in action when pressing Ctrl-Shift-C: