Code to save data

Hi Guys,

Maybe this is easy for you but not for me.
I have two userform:
- UserForm1 (for entry data): contain textbox1 (as entry text) and commandbutton1 (as Save button)
- Userform2 (as records only): contain label1
Below this code under Userform1

Please Login or Register  to view this content.

If data entry on textbox1 (Userform1), then will be saved on label1 (Userform2) after commandbutton1 (as Save) pressed. Also the textbox1 will be reset/clear after commandbutton1 clicked.
I don't know how to create code to save the data on UserForm2.
If anyone of you Guys, can helps me, I am really appreciate.

Best Regards,
Iqbal

Hi Jeff,

Yes, your code exactly like my expectation.
And, I add more one button "Exit" as commandbutton2. This button to save in a file which is opening now.
The aim is after fill up on the "textbox1", then press save. It will save on the userform2 itself.
And if "Exit" (commandbutton2), then the character what ever it wrote, will be saved in the file itself.
This file, i would like to send to other people and if he re-send back to me, what ever he wrote, it will be back to me as he was input.
I attached the file for your reference.
Thank you so much Sir and appreciated.

Best Regards,
Iqbal

Hi Jeff,
I've been modified and i found the simple code how to save the workbook.
Look like i have to print on Worksheet also, then i can save the data entry.
I use this code to save the data:

Please Login or Register  to view this content.

Thank you so much Sir, I will add reputation for you.

Best Regards,
iqbal