save workbook when userform is closed

[kelly mort]

Hello all,
I wanna save my workbook when I click the close button on my userform form. How do I code it?
Thanks
Kelly

 

[JackDanIce]

Try:

Thisworkbook.Save

 

[kelly mort]

Try:

Thisworkbook.Save

Sure. But how do I use it to relate the close button on the form itself. I am not talking about the button I have created myself but the default button .
Regards
Kelly

 

[Fluff]

Try

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    
    ThisWorkbook.Save
    
End Sub

 

[kelly mort]

Try

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    
    ThisWorkbook.Save
    
End Sub

Oh okay thanks. I just skipped this.
Thanks for pointing to the right direction
Kelly

 

[Fluff]

Glad to help & thanks for the feedback