+ Reply to Thread
Results 1 to 3 of 3

Return value of multiple rows in an Excel sheet into one textbox, with tabs between values

  1. #1
    Registered User
    Join Date
    02-02-2013
    Location
    NL
    MS-Off Ver
    Excel 2010
    Posts
    63

    Return value of multiple rows in an Excel sheet into one textbox, with tabs between values

    Hi all,

    I am struggling with how to include VBA code that returns the content of multiple cells in row and column style.
    The following example is how it is stored in the Excel sheet, the R and C represent a row and column number.
    The range is an example and depending on the number of records, could be enlarged to 50 rows and 10 columns.

    Table.jpg

    Hence, the content of the above 12 cells (A1:D4) should be presented in a textbox in the exact same layout with a "tab" between each cell value.

    Does anyone have an idea?

    Thanks!
    Last edited by Martijn79; 04-13-2014 at 09:23 AM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    How about using a multi column listbox instead of a textbox?
    If posting code please use code tags, see here.

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Return value of multiple rows in an Excel sheet into one textbox, with tabs between va

    Please Login or Register  to view this content.
    Ben Van Johnson

+ 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. Replies: 0
    Last Post: 10-07-2013, 10:24 AM
  2. [SOLVED] Multiple Rows of Sheet Tabs?
    By HUNTXTRM in forum Excel General
    Replies: 4
    Last Post: 08-15-2013, 07:44 PM
  3. [SOLVED] Is there a way to stack the sheet tabs in multiple rows?
    By flyboy54 in forum Excel General
    Replies: 3
    Last Post: 05-01-2013, 08:23 AM
  4. Replies: 2
    Last Post: 12-05-2012, 01:52 PM
  5. Replies: 0
    Last Post: 05-10-2012, 12:54 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