+ Reply to Thread
Results 1 to 43 of 43

Text from text box to cell

  1. #1
    Registered User
    Join Date
    07-18-2005
    Posts
    16

    Text from text box to cell

    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

  2. #2
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  3. #3
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  4. #4
    Registered User
    Join Date
    07-18-2005
    Posts
    16

    Text from text box to cell

    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

  5. #5
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  6. #6
    Registered User
    Join Date
    07-18-2005
    Posts
    16

    Text from text box to cell

    Thank you all...



    Greiffenberg

  7. #7
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  8. #8
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  9. #9
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  10. #10
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  11. #11
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  12. #12
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  13. #13
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  14. #14
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  15. #15
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  16. #16
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  17. #17
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  18. #18
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  19. #19
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  20. #20
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  21. #21
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  22. #22
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  23. #23
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  24. #24
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  25. #25
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  26. #26
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  27. #27
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  28. #28
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  29. #29
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  30. #30
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  31. #31
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  32. #32
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  33. #33
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  34. #34
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  35. #35
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  36. #36
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  37. #37
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  38. #38
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  39. #39
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  40. #40
    Bob Phillips
    Guest

    Re: Text from text box to cell

    Pretty sure you will need VBA.

    What sort of textbox is it?

    --
    HTH

    Bob Phillips

    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  41. #41
    Ian
    Guest

    Re: Text from text box to cell

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

    --
    Ian
    --
    "Greiffenberg" <Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd3uf_1121684715.5021@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:
    > http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  42. #42
    Bob Phillips
    Guest

    Re: Text from text box to cell

    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" <Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com>
    wrote in message
    news:Greiffenberg.1sd9el_1121691921.4345@excelforum-nospam.com...
    >
    > 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
    >
    >
    > --
    > Greiffenberg
    > ------------------------------------------------------------------------
    > Greiffenberg's Profile:

    http://www.excelforum.com/member.php...o&userid=25311
    > View this thread: http://www.excelforum.com/showthread...hreadid=387954
    >




  43. #43
    Registered User
    Join Date
    07-18-2005
    Posts
    16

    Thank you all!!!

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1