When you insert the textbox control in your form you will see the properties
windows appearing on the bottom left of the visual basic editor. Click on the
"Categorized" tab, scroll down to where the data properties are, and type in
the "Control Source" the Worksheet Cell Reference (ie.: Sheet1!$A$1)
Then scroll back up to the appearance properties and change the
"SpecialEffect" from "2 - fmSpecialEffectSunken" to "0 - fmSpecialEffectFlat"
and "the BackColor" to a color that will better represent the data currently
in the Cell.
Then Insert a second text box and do exactly the same thing except for
changing the Appearance of the object so the user understand that is a field
where they can key in data. Now insert a "CommandButton" Control and label it
"Update Data"; behind this botton you insert the code that will send the data
to the spreadsheet on_click, for example: Sheets("Sheet1").Range("A1").Value
= Textbox2.value

I hope this is what you need,

Cheers,

"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?