Thread: Autosave
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default 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