Save delay after input

Hello everyone,

VBA newbie here. I am looking for a way that will allow my excel file to automatically save after a delay of data input.

For example:

User Inputs Data --> Timer Starts (1min)
5 seconds pasts.
User inputs Data --> Timer Restarts (1min)
1min pasts...
Excel File Saves - until the user starts inputting data again

Any thoughts?

Hello and Welcome to the Forum

You should be able to work with this code to get what you want;

http://www.excelforum.com/excel-prog...-workbook.html

It's Post #7 you'll need.

Remove the ThisWorkbook.Close statement in the code and it'll just save

Alternatively there is also the built in AutoSave function which may do the job just as well?

https://support.office.com/en-us/art...f-a80415b92f99

Thanks PaulSP8!