Text from text box to cell

G

Greiffenberg

Does anybody know a formula (not VBA) to get text from a text box to a
cell?

I can get text from a cell to the cell box, but is it possible the
other way around?

Greiffenberg
 
I

Ian

You can set the Linked Cell in the textbox properties. That way, textbox and
cell will always be the same, whichever one you change.
 
G

Greiffenberg

Hi, and thanks for the fast reply....

I'm not sure how you do "the linked cell" I've tried the help with no
help...

I'll try to elaborate a little more:

I'm building a worksheet with a standard sheet with a textbox. I would
like the text of the text box to link to a cell, and then copy my
standard sheet to make new worksheets...

Did that make sense?

Greiffenberg
 
B

Bob Phillips

If it is a control toolbox textbox, activate design mode, double-click on
the textbox which takes you to the VBE IDE. Open the properties window, F4,
and set the linkedcell there.

--
HTH

Bob Phillips

"Greiffenberg" <[email protected]>
wrote in message
news:[email protected]...
 
G

Greiffenberg

I ended up piecing a lot of different VBA code together, and after a
while it worked....

Big thanks for all the help in this forum....

Greiffenberg
 
Top