+ Reply to Thread
Results 1 to 2 of 2

Link Contents of a Text Box to Another Cell

  1. #1
    Registered User
    Join Date
    09-28-2010
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    2

    Exclamation Link Contents of a Text Box to Another Cell

    Hi,

    I'm trying to figure out how to link the contents of a text box to another cell on a worksheet within the same workbook. I may be going about this the wrong way, so let me just summarize what it is I'm trying to do:

    I have worksheets all formatted off the same "memo" template, and they include a text box, because that's the only way I can format the text exactly how I want the memo to print out. I also have a summary page at the beginning of the workbook that is linked to various cells within each of these worksheets. This is so I can get a quick snapshot of important information contained in each memo. I'd like the information in the text box to also show up on the summary page, but I don't know how to link the contents. I know how to link a cell to a text box so that the contents of the cell show up in the text box, but what I am trying to do is the reverse.

    Do I need a macro for this? Can anyone help?? Thanks!

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Link Contents of a Text Box to Another Cell

    Hi Imadu,

    A 'Forms' text box is only one way. You can assign the text box a formula (e.g. =A1) so the text box displays the contents of the cell, but it is only one way as you have already discovered.

    You might want to change the text box to an 'Active X' Text box.
    An 'Active X' text box links both ways. Put the cell number (e.g. C4 or Sheet2!C4) in the 'Linked Cell' box in the Properties Window. You get to the 'Properties' window by right clicking on the text box while in 'Design Mode'.

    See the following for how to create an 'Active X' textbox: http://www.contextures.com/excelvbatextboxcreate.html

    Lewis

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I link cell contents across worksheets?
    By ActionJaxon in forum Excel General
    Replies: 2
    Last Post: 03-01-2009, 08:47 AM
  2. Replies: 1
    Last Post: 06-27-2006, 12:10 PM
  3. All of contents in cell don't link
    By CMIConnie in forum Excel General
    Replies: 0
    Last Post: 05-02-2006, 05:00 PM
  4. [SOLVED] Cell only shows link in text, not contents of reference cell
    By Jay Mac in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-23-2005, 04:05 PM

Tags for this Thread

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