Save button on a Userform

I have a userform that pulls data from certain cells within a spreadsheet, the user can change the information on the userform i have that part covered. My problem is i cant remember how to code the save button the new information is saved to the sheet and the user form is closed.

Any Help please

Chris

Hi Cjames2012

You could use something like this on the command button.
Just remember to change the workbookname to your file name.

Please Login or Register  to view this content.

Cheers
Dan