how to detect paste

  • Thread starter Thread starter mjb267
  • Start date Start date
M

mjb267

is their code available to establish if a user is pasting data rathe
than manually entering it?

ie, i want a macro to run if data is pasted in, but do nothing if dat
is entered cell by cell.

your help is appreciated
thanks
 
Hi
AFAIK there's no such event which is triggered by pasting. So no chance
to get this differentiation
 
You can replace the built-in Paste buttons on the Edit menu and the right click
menu with your own Paste buttons that will do whatever you like.
You can also use OnKey to change what happens when you hit Ctrl+V .

Regards,
Vic Eldridge
 
I found another way around it, but that is an awesome idea! thanks fo
your help
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Altered pasting functionality 3
Number stored as text 4
How to use OFFSET in VBA 1
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Copy excel cell to webform (search box) and press enter 10
macro to copy data and paste to a new sheet in next available cell 2
How to make web image on Excel worksheet permanent 3
Macro for checking data in a cell against another cell andcopying/pasting data 8

Back
Top