+ Reply to Thread
Results 1 to 10 of 10

Choose to List Box

  1. #1
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Choose to List Box

    Hi Guys, Do you have idea if possible to search the MR NO. then show to list box the "MR NO." "QUANTITY AND "DESCRIPTION" and doubleclick the value go to Textbox and search again to continue to met the requirement im also thinking if better to use combo box. please give me idea


    Thanks and advance


    -im sorry guys i don't have knowledge to use the listbox
    Attached Files Attached Files

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

    Re: Choose to List Box

    Try
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Re: Choose to List Box

    Thanks for the help @jindon but i think much better to see the description to the listbox...

    i change the this code
    Please Login or Register  to view this content.
    but when i click we have a problem to the inserting to the textbox
    Please Login or Register  to view this content.
    also want to ask what is the purpose of this code
    Please Login or Register  to view this content.
    ?
    Last edited by Chandria; 10-16-2017 at 08:13 PM. Reason: adding tag

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

    Re: Choose to List Box

    Don't change the code.
    Just change Listbox1 columncount property to 3.

  5. #5
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Re: Choose to List Box

    -jindon i need your favor if search again only add not to replace the previous value of text box

    Thanks again

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Choose to List Box

    You only have 5 set of text boxes.
    How do you want when you d-click listbox more than 5 time?

  7. #7
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Re: Choose to List Box

    actually i want to add text box to 10 set and if search again the value of number 1 not to replace the value add to to number 2


    -Thanks

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Choose to List Box

    Then just delete one line
    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    169

    Re: Choose to List Box

    @ jindon thank you very much. i very appriciate your help.

  10. #10
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Choose to List Box

    You are welcome.

    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. Need help with a choose from a list formula
    By afe5026 in forum Excel General
    Replies: 2
    Last Post: 10-03-2014, 06:33 PM
  2. [SOLVED] choose names from a list
    By jimboryan in forum Excel General
    Replies: 13
    Last Post: 05-25-2014, 11:20 PM
  3. [SOLVED] Create a list according what i choose in A1!
    By apla in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2013, 10:39 AM
  4. formula to choose list
    By bloo7997 in forum Excel General
    Replies: 1
    Last Post: 10-26-2012, 12:52 PM
  5. How to choose numbers from a list
    By bebo021999 in forum Excel General
    Replies: 4
    Last Post: 11-09-2011, 10:05 PM
  6. Replies: 1
    Last Post: 05-17-2011, 08:44 PM
  7. Choose from List
    By NNothard in forum Excel General
    Replies: 4
    Last Post: 10-09-2006, 11:53 AM

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