VBA Excel. How can I compare a cell entry against a named range ON PASTING VALUES

P

puddingmeister

Hi,
Not sure if this is even possible, but it would solve many issues in
my workplace?
I need to compare a cell entry against a named range (easy enough).
But the compare needs to be triggered by a 'paste special/values' in
cell B3. Does anyone know if this is even possibe.
I could do it via a macro button but the boss has spoken, and I must
obey!!
I would appreciate any advice.
Thanks,
Roy
 
J

Jeff Hopper

Excel does not offer an "on-paste" event. My approach would be to create a
macro that does both the pasting and comparing. Besides assigning a button
to the macro, you could choose to re-assign the Ctrl-V keyboard combination
from the standard paste operation to your own.

Jeff Hopper
Hopper Consulting, Inc.
 
Top