Extract TextBox value in Excel 2007

[CBV]

I've searched all over and cannot find a solution to this.

Is there a way, either via a formula or a function, to extract the values (text) from a Textbox that sits on a spreadsheet (not a form) and put them into a cell in the same worksheet?

Example: Get the contents of TextBox1 and put it into cell A1.

Thank you.

 

[Smitty]

Welcome to the Board!

Why not just use the TextBox's LinkedCell property?

You can also do something like this:

<font face=Calibri><SPAN style="color:#00007F">Sub</SPAN> TBText()<br>    Range("A1").Value = ActiveSheet.TextBox1.Value<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

HTH,

 

[CBV]

I can't get the Properties window to show the TextBox; it only shows the Worksheet.

I select the TextBox, then click "Properties" in the Developer Ribbon, but it won't show the TextBox. What am I missing? The LinkedCell option sounds like exactly what I need.

 

[Smitty]

You also need to be in Design mode in order to expose it.