get a cells value to equal a textbox value when a button is pressed

Hi I am after a way to update the value of a cell (M4) in a worksheet (worksheet1) to the value of a textbox (textbox9) in a userform (userform 1) when a command button (commandbutton1) is pressed. The command button is located in the user form.

This userform is used to prefill lots of data on multiple worksheets so this is only a part of the code but once I can figure out this part I will be right.

I have tried to use the following code with no sucsess

Please Login or Register  to view this content.

however i can get this to work in reverse ie update the textbox with the cells value

Please Login or Register  to view this content.

Another way I have thought of doing this is just to have the cells updated as you type using the ControlSource. However I cant figure out the format needed to enter it straight in the properties window, and when I try using code

Please Login or Register  to view this content.

nothing seems to update in the cells.

I have looked in the forum for similar questions and answers but nothing is seeming to work. Any help would be greatly appreciated.