ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Autosave (https://www.excelbanter.com/excel-programming/327921-autosave.html)

MBlake

Autosave
 
Hi,
Please could someone advise if there is any VBA code to automatically save a
workbook either after a set time or preferably following an entry to the
last part of a userform using combos boxes from the control toolbox?

Thanks,
Mickey



Jim Thomlinson[_3_]

Autosave
 
thisworkbook.save

Instead of placing it in the change event of a combo box (which could become
annoying if the user changes it 3 of 4 times) why not put in in the userform
terminate or deactivate events. Probably better there but that is just my 2
cents...

HTH

"MBlake" wrote:

Hi,
Please could someone advise if there is any VBA code to automatically save a
workbook either after a set time or preferably following an entry to the
last part of a userform using combos boxes from the control toolbox?

Thanks,
Mickey





All times are GMT +1. The time now is 03:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com