VBA start from beggining when hitting "ESC"

[vio.coman]

Hi everybody,

I've got the code below that I've inserted in several excel workbooks to collect data from different users.
Some users have hit the "ESC" button while the code was running, moment when the sequence of the code was interrupted and no data could be collected when the users introduced data into Sheets("A").

Is it possible add to the code something that would rerun the whole code from the beggining each time the "ESC" button is hit while the code is running?

Any suggestions are appreciated, thanks!

regards

Please Login or Register  to view this content.

[:) Sixthsense :)]

Disable the Esc Key in your code

Please Login or Register  to view this content.

[vio.coman]

Sixthsense,

simple yet effective. Thanks!

regards