I have a text box called txtName on my form that a user input data. I want that data to popluate to a cell C7 in a worksheet called hrfromm when the user clicks on the command button call cmdOK. I tried the code below but no luck. Any ideas??

Private Sub cmdOK_Click()
C7.Value = txtName.Value
Unload Me
End Sub