In my code when a user opens a worksheet I show him a MsgBox asking him if he
is ready to paste the clipboard contents into a certain cell on the
worksheet. The code that executes after the values have been pasted sorts the
values the user has pasted.
The problem is that the sort code executes as soon as the user clicks "yes"
to dismiss the MsgBox, thereby not allowing him an opportunity to perform the
paste operation.
How can I pause the code when the MsgBox is dismissed so that the user can
paste in the values from the clipboard, and then have the code resume
execution after the paste operation has been completed?
All help will be much appreciated.
Or, is there a better way to code for this sequence of events?