I would like to something that is similar to behavior to ctrl-x and ctrl-v but with additional commands. So the user is on a particular cell and when the user clicks ctrl-x on that field I do some validations and pickup the location and value in the cell along with the one beside it. Then I want the user to click on another cell and when they click ctrl-v I will run some validations to make sure this is an allowable place to paste the information. There are two things I am trying to accomplish; 1) this variation on the ctrl-x/ctrl-v is only for a particular worksheet 2) I can't figure out how store the 'cut' information until such as a time tat the user chooses another valid cell and clicks ctrl-v. Meaning the cut takes place but the code won't continue until the user clicks a valid destination and clicks ctrl-v.
I did ok picking up the data from the cut, but waiting for the user to choose another cell and clicking ctrl-v for paste is where I have no idea how to do.
Thanks
Bookmarks