How Userform Commandbutton actually Save data into excel sheet?

Hello Everyone!

I have a Userform.Which is working perfectly to send data to excel sheet.

In the userform there is command button (commandbutton1) which is used to send data to excel sheet...This only send data but it actually does not save it into excel sheet.When I close excel sheet it asks do you want to save changes?

But I need when commandbutton1 is press to send data to excel sheet , it should actually save data into excel sheet.

Here is code

Please Login or Register  to view this content.

Plz Help
Kind Regards
z-eighty2