Macro to undo previous action

Hi all,

After the kind help of Leith Ross I have made an attempt to add to the code in the attached.

It all seems to work ok but i cannot work out how to get the undo function to work.

In the search sheet clicking on "select" will copy the selected search result to the top of the table, a pop up then asks for a quantity which if entered works ok, there is also a warning pop up if you click cancel.

The problem im having is that i cant get the "cancel" - "yes" series of selections to remove the last lot of copied text from the "select" click from the table of selections.

Sadly im a VBA noob so the code is borrowed and clumsily modified by myself.

Also as an aside a friend of mine cannot open this file in Excel 2013, is the code I have added a bit out of date?

Regards,

Adam

Quote Builder test.xlsm