Is there any reason this shouldn't work work in Office 2007, with a TextBox
directly on a spreadsheet rather than a form? I can't get this to work and
wonder if I am missing something in my resource references and if anyone
knows what that might be.
--
Alan


"IC" wrote:

It actually works both ways, keeping the textbox and the cell in sync.

Ian

"sea" wrote in message
...
That will input the value from a cell into a textbox. What I am looking
for
is to go the other direction. For example, I want the value of the text
entered into textbox1 to be extracted into cell A!.
Thank You
sea

"IC" wrote:

In Properties-Linked cell for the textbox, type the full cell address of
your target eg Sheet2!A1

Ian

"SEA" wrote in message
...
Is there a way to extract data from a textbox and use this data in a
cell
on
a different sheet? The cell would then update when the textbox was
changed.
Can the textbox be refecenced with a function or can it be done with
VBA?