+ Reply to Thread
Results 1 to 6 of 6

Fill List Box with Five Text Boxes and Put List Box on Sheet

  1. #1
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Pakistan
    MS-Off Ver
    2013, 2016
    Posts
    283

    Fill List Box with Five Text Boxes and Put List Box on Sheet

    Hi.
    I have a user form in excel vb that have one list box and five text boxes.
    I want to fill the list with five columns through text boxes.
    And when I press Command Button then data should transfer on the sheet in five columns.

    Can anyone Help me please.

    I shall be very thankful for your help.
    Attached Files Attached Files
    Last edited by AmirSoft; 12-25-2014 at 02:32 AM.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Fill List Box with Five Text Boxes and Put List Box on Sheet

    Not sure to get it right, there is:
    - 5 textboxes filled with free text
    - Purchase button to merge textboxes values to the listbox
    - SaveRecord button to write textboxes values to columns A to E in sheet1
    is it ?
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Pakistan
    MS-Off Ver
    2013, 2016
    Posts
    283

    Re: Fill List Box with Five Text Boxes and Put List Box on Sheet

    At first write data in five text boxes and then press command button. Data should enter in list box columns.
    When we have some data in list box then press command button 2 and data should transfer on sheet in five columns.
    when again we enter any data should transfer on sheet after previous rows.

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Fill List Box with Five Text Boxes and Put List Box on Sheet

    Perhaps this will work for you.
    Note that I made the ListBox a 5 column list box and multiselect and removed the ColumnHeads.
    All the selected rows of the text box will be transferred to the sheet.
    Accomidations for editing a prior listbox entry could (should) be made.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  5. #5
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Pakistan
    MS-Off Ver
    2013, 2016
    Posts
    283

    Re: Fill List Box with Five Text Boxes and Put List Box on Sheet

    Hi mikerickson
    You have great experienced.

    I am very happy to see this code
    I don't have words to say you Thanks. Today my whole day passed in this attempt.

    Anyway Thank You so Much.

  6. #6
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Fill List Box with Five Text Boxes and Put List Box on Sheet

    A bit late ( XMas time ) but see attached
    Attached Files Attached Files

+ 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. [SOLVED] code populates list boxes in active sheet, but does not populate boxes in subsequent sheet
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-13-2014, 10:26 AM
  2. Creating user prompted text boxes to fill out an excel sheet for an internship
    By nyballer999 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2014, 06:45 AM
  3. Multichoice list boxes and use of Dictionary (3 cascading list boxes)
    By jerem123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2013, 09:45 AM
  4. Text colors in List boxes
    By fraz627 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2012, 07:15 AM
  5. Resizing text in list boxes
    By Paulxlus in forum Excel General
    Replies: 3
    Last Post: 03-02-2008, 07:46 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