Hi Cedtech,

Try:

'=============
Private Sub cmdOK_Click()
Sheets("hrfromm").Range("C7").Value = txtName.Value
Unload Me
End Sub
'<<=============


---
Regards,
Norman


"cedtech23" wrote
in message ...

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


--
cedtech23
------------------------------------------------------------------------
cedtech23's Profile:
http://www.excelforum.com/member.php...o&userid=31022
View this thread: http://www.excelforum.com/showthread...hreadid=506903