ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I make an excel cell equal to the value of a frame object text box (https://www.excelbanter.com/excel-worksheet-functions/74005-how-can-i-make-excel-cell-equal-value-frame-object-text-box.html)

directionalman

How can I make an excel cell equal to the value of a frame object text box
 
I recently post a question about how to apply the value of a text box
to a cell which was answered very well.

Now I am attempting to do the same thing with a text box which is a
frame object. I would like to apply the value a "frame object text box"
to a cell of another sheet in the same workbbok. This control does not
have a linkcell property as the the regular text box does. It has a
controlsource property, but that will only put data into the text box
from a cell. I would like the data to go from the text box into the
cell or into another text box for display purposes.

Thanks


directionalman

How can I make an excel cell equal to the value of a frame object text box
 
Sorry, the Controlsource DOES actually do this corectly. I was doing
something wrong previously.



All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com