You can use the Text Box Control for both, and in the value properties point
to the cell reference where the data is currently stored; make sure you set
to true the locked properties. For the data going you do the same, you placed
a cell worksheet and cell reference in the value, and create an on enter
event that will submit the data in the text box to the cell reference
Also, you may want to change the background colors and the special effect to
flat for the data currently in the spreadsheet for distinction purposes.



"todd" wrote:

I am trying to create a UserForm that will display data from a worksheet onto
the UserForm, while at the same time allowing input from the same UserForm
from a TextBox - what toolbox feature should I use, and how would I do this?