+ Reply to Thread
Results 1 to 9 of 9

[Userform] How to input data in Listbox from textbox with more than 10 columns

  1. #1
    Registered User
    Join Date
    02-28-2020
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    22

    [Userform] How to input data in Listbox from textbox with more than 10 columns

    Hello.
    I have a userform with 2 parts, the 2nd part originally I have 10 text boxes and with a add button, the data with then show on the listbox, code as below

    Please Login or Register  to view this content.

    It works perfectly however now I need to add 8 more text boxes.
    Listbox Additems only can show max 10 columns.
    I try to search online, find something like this, but dont know how to apply in my case.
    Especially the "Textbox" & i, since I have more textbox in part 1, seems it can't work.

    I need to add new data in the excel sheet through the userform, so cannot use RowSource method.

    Can anyone help to modify? Thank you very much.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,509

    Re: [Userform] How to input data in Listbox from textbox with more than 10 columns

    Change to
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-28-2020
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    22

    Re: [Userform] How to input data in Listbox from textbox with more than 10 columns

    thank you for your reply, but how can I link back with my array? because I have 18 text boxes need to show in the listbox

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,509

    Re: [Userform] How to input data in Listbox from textbox with more than 10 columns

    Change to
    Please Login or Register  to view this content.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,509

    Re: [Userform] How to input data in Listbox from textbox with more than 10 columns

    If you are keep adding to the ListBox then
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    02-28-2020
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    22

    Re: [Userform] How to input data in Listbox from textbox with more than 10 columns

    thank you so much for your prompt reply. I tried and it works for only one row.
    If I need to keep adding the the data by the textbox (no limit for the rows) and without replacement
    how can I change?

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,509

    Re: [Userform] How to input data in Listbox from textbox with more than 10 columns

    See my last post.

  8. #8
    Registered User
    Join Date
    02-28-2020
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    22

    Re: [Userform] How to input data in Listbox from textbox with more than 10 columns

    It works perfectly!! Thank you so much for your help!!
    Have a nice day.

  9. #9
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,509

    Re: [Userform] How to input data in Listbox from textbox with more than 10 columns

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Want to one more textbox to search the data in listbox (Userform)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2017, 08:00 AM
  2. Transfer listbox and textbox data from userform to spreadsheet
    By NellieNoggs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2014, 02:35 PM
  3. [SOLVED] user form to input data according to text in textbox and listbox
    By a.hudrea in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2014, 04:27 AM
  4. Get Data from UserForm (TextBox, ListBox) doesnt work
    By BorisMKD in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-15-2014, 05:07 AM
  5. Transfer Data From One Userform Listbox to Another Userform Listbox with 11 columns
    By sparkoft in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-18-2013, 10:54 AM
  6. [SOLVED] populate userform listbox from textbox input
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2013, 10:05 AM
  7. Userform Textbox to input data to worksheet
    By wrobs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2010, 01:02 AM

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