+ Reply to Thread
Results 1 to 3 of 3

Multiple rows to view in one Form text Box

  1. #1
    Forum Contributor
    Join Date
    02-16-2012
    Location
    London, England
    MS-Off Ver
    Excel mac 2011
    Posts
    238

    Multiple rows to view in one Form text Box

    Hi there,

    Is there a way to grab say 6 cells data from a column on a spreadsheet and display it in a single text box? I know how to get text from one cell into a text box, but for what I have in mind, getting all the data from a short column and into a large text box would work best visually, I have tried this, but it only pastes the first cell of data:
    Please Login or Register  to view this content.
    Would be nice if this is possible,

    Kind regards
    Rob

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Multiple rows to view in one Form text Box

    this gives 3 different strings you can use

    Please Login or Register  to view this content.
    Kind regards
    Leo

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Multiple rows to view in one Form text Box

    Try:-
    Please Login or Register  to view this content.
    Or if textbox from "Insert" TexBox", then perhaps,Either of the below:-
    Please Login or Register  to view this content.
    Last edited by MickG; 09-19-2016 at 06:11 AM.

+ 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. Multiple Lines in User form text box in Separate rows
    By prabhucse in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-05-2016, 05:24 AM
  2. Multiple Lines in User form text box in Separate rows
    By prabhucse in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2016, 12:28 AM
  3. Multiple Lines in User form text box in Separate rows
    By prabhucse in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2016, 12:28 AM
  4. [SOLVED] Objects are visible in Design View but not in Form View
    By Lloyd Blankfein in forum Access Tables & Databases
    Replies: 3
    Last Post: 06-14-2013, 09:57 AM
  5. Condense multiple rows into a table view
    By Jonsocks in forum Excel General
    Replies: 3
    Last Post: 06-09-2010, 09:47 AM
  6. Grouping multiple rows together by month for summary view
    By patrickgamer in forum Excel General
    Replies: 0
    Last Post: 05-07-2010, 11:23 AM
  7. Rows are hiden in normal view but not printing view
    By aletoconstco in forum Excel General
    Replies: 1
    Last Post: 08-17-2006, 04:10 PM

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