Hi Cassy01,
Try this in your userform and change the commandbutton and textbox name
and sheet name to fit.
Code:
--------------------
Private sub Commandbutton1_Click()
Sheets("Sheet1").Activate
Cells(64, 1) = Textbox1.Text
End Sub
Private Sub Textbox1_Change()
End Sub
--------------------
Hope this helps,
Larry
--
keithl816
------------------------------------------------------------------------
keithl816's Profile:
http://www.excelforum.com/member.php...o&userid=21287
View this thread:
http://www.excelforum.com/showthread...hreadid=474205