Use the textbox from the control toolbox toolbar.

Rightclick on it and choose properties (while in design mode--another icon on
that toolbar).

Type in the address of the linked cell in the .linkedcell property.

You may want to play with these properties, too:

.enterkeybehavior to true (hitting enter creates a new line)
.multiline to true
.wordwrap to true
.scrollbars to what you want.

Exit design mode and test it out.

McGuff wrote:

Is there a way to have cells reference a text box so that values typed into
the text box automatically update values in the cells?

--

Dave Peterson