Writing values from forms to sheet

Hi,

I'm fairly new to using VBA and have a problem writing back values from a form to a worksheet. Here's what I've done

When the form initializes this occurs

Dim MyRange as range
Set MyRange = Sheets ("Sheet1").Range ("A1")

I have a control on the form which, when updated, I'd like to store the value in the above range therefore within the controls subprocedure I have

Private MyControl_Afterupdate()

MyRange = MyControl.Value

End Sub

When I enter a value in the form I don't get any error messages but I'm also not getting the value stored in the worksheet. Any help would be appreciated

Many thanks

Mike