+ Reply to Thread
Results 1 to 3 of 3

Link multiple cells to a textbox

  1. #1
    Registered User
    Join Date
    10-12-2016
    Location
    US
    MS-Off Ver
    2013
    Posts
    8

    Link multiple cells to a textbox

    Hi,

    I'd like to link the multiple cells to a dynamic textbox and keep the values in the column format as they appear in column A on sheet1. Any help would be appreciated.

    Thanks!
    The values under column A are as follows.
    A1 = Time
    A2 = Date
    A3 = Name

    These values are expected to be shown in a textbox as follows.

    Time
    Date
    Name

  2. #2
    Registered User
    Join Date
    09-03-2016
    Location
    Perth, Australia
    MS-Off Ver
    Office 365 Excel 2016
    Posts
    22

    Re: Link multiple cells to a textbox

    One option would be to put this formula in B5

    =(TEXT(B1,"hh:mm AM/PM") & CHAR(10) & TEXT(B2,"dd/mm/yy") & CHAR(10)& B3)

    Then apply text WRAP to B5l

    Then link the text box to B5

  3. #3
    Registered User
    Join Date
    10-12-2016
    Location
    US
    MS-Off Ver
    2013
    Posts
    8

    Re: Link multiple cells to a textbox

    Thank you!

+ 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. Two way link for multiple cells
    By pinnnen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2016, 03:03 PM
  2. Replies: 2
    Last Post: 11-28-2014, 09:16 AM
  3. Find and Replace multiple cells based on edited textbox value
    By Stratocaster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2014, 08:54 PM
  4. Link multiple values in a single textbox: New to VBA - Please help!
    By afderose in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2013, 06:33 AM
  5. Link one textbox to many cells to view cell's content
    By Terrafai in forum Excel General
    Replies: 1
    Last Post: 03-07-2012, 01:56 PM
  6. [SOLVED] How do you link multiple cells in a worksheet?
    By JK (New England Coffee) in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-27-2006, 03:10 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