Command Button To Save & Close

[Mooseman60]

Hi

Can anyone give me the code for a userform command button to save data to worksheet and close the userform at the same time

Thanks:help

[OBP]

Is this Excel or Access?
Access does not need a save when closing a form.

[Mooseman60]

Sorry I put it in the wrong forum it is excel I will re post

Thanks