Allowing a user to input text and then reflect the change on a worksheet.

Is the textbox on a sheet or on a userform? If it is on a sheet then you can have the text box linked to a cell. You can select the cell from the properties of the text box, there is a selection named LinkedCell ( i think that is the name). If it is on a userform you'll have to code for the change on the sheet. Something like this:

Sub TextBox1_Change
Sheets("Sheet1").Range("A1").Value = TextBox1.Text
End Sub

I think those should do it. Hope it works

Ryan

Hello Ryan,

That works great for passing text, but I need to
be able to have the user change it and store it.

In other words the user can type in a number and
then that number is passed on to a designated area
in the worksheet, but it can be several cells.

Thanks,

Kurt

Kurt,

Don't know what you need done, try to give me some more details so I know what's going on. Thanks

Ryan