Extract Data From Textbox

[Guest]

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?

 

[IC]

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

Ian

 

[Guest]

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

 

[Jason Morin]

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

 

[Guest]

Thank you!
Works perfect

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

 

[IC]

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

Ian

 

[Alan Pederson]

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.