error message when someone does not paste into 2 cells

Hi all-

Is there a way to pop up an error message if someone does not paste into 2 cells at a time?

The problem is that I do not want users to be able to paste a part number (Column E) without the description (Column F), if they do only one (E or F) I want an error message to appear.

Thanks for the help.

-Mike

Hi Mike. You cold loop through the part numbers in column E and use 'Offset' to see if the corresponding cell in column F is empty. If it is empty, you can have a message box pop up with a warning. If you need help with this, post a copy of your file with a detailed description of what you would like to do.

If you used a userform this could be set up to only except both inputs.

This macro would go into the worksheet code module. I'm not sure if this will suit your purposes. It will prompt the user to put in the missing information each time a part number or description is entered.

Please Login or Register  to view this content.

Thanks that worked good, but I don't want it to pop up if they actually paste into both columns at the same time. Is that possible?


If the user paste both Column E & F it does nothing.


If the user paste only Column E & not F or Column F & not E it the message will appear


Thanks in advance for the help!

Try:

Please Login or Register  to view this content.