|
|
|
|
Thank you!
Works perfect
"Jason Morin" wrote:
While in design mode, right-click the textbox, go to View
Code, and use:
Private Sub TextBox1_Change()
Range("A1").Value = TextBox1.Value
End Sub
HTH
Jason
Atlanta, GA
-----Original 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
news:E147EBB3-CDD3-4DDA-8C82-
...
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?
.
|