I build a userform that consist a Submit button to transfer info to worksheet, then another button "Save" the sheet.
My question is that, is there any way I can Save it at the same time when I click "Submit"?

Thank you so much for you time.
Kl