+ Reply to Thread
Results 1 to 3 of 3

Text Boxes

  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2013
    Posts
    35

    Text Boxes

    I have a situation where I have a scrolling ActiveX text box on one Tab in a Excel 2007 spreadsheet and I want what ever is entered into another ActiveX text box on another Tab within same spreadsheet - is this possible?

    Also in a scrolling ActiveX TextBox a carraige return does not seem to work - is that not possible?

    Thanks,
    Mark
    Last edited by britinva; 11-21-2012 at 05:36 PM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,459

    Re: Text Boxes

    Select a cell (anywhere in your workbook) that will hold the contents of the text boxes. Give it a name (type the name into the Name Box, the box that shows the address of the current selection up in the upper left corner above the top of column A). Set the LinkedCell property of both text boxes to be that name. The contents of both text boxes will always be the same.

    If you do not want to use the LinkedCell method, or you want the replication of content to go only one way, then it requires VBA code.

    To go to a new line in a text box type CTRL-ENTER instead of just ENTER.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    09-18-2012
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Text Boxes

    Thanks - would never of thought of using an intermedary cell to pass values. Seems to work great!

    Thanks Again
    Mark

+ 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