Susan,

Use code like

Range("A16").Value = TextBox1.Text


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Susan Hayes" wrote in message
...
Hello:


Private Sub TextBox1_Change()

End Sub


How can I get a number written in with the TextBox to appear in
cell A16:

Eg. If I were to type in the number 1.2455 in the text box how
can I have it appear in cell A16?


Thank you

Susan