+ Reply to Thread
Results 1 to 7 of 7

Modify my SEARCH userform from 1 return to multiple returns if needed?

  1. #1
    Forum Contributor
    Join Date
    10-25-2016
    Location
    Derby, England
    MS-Off Ver
    MS 2013
    Posts
    228

    Modify my SEARCH userform from 1 return to multiple returns if needed?

    Hi,

    I created this search userform with help from various people from this forum and it works great but recently a problem has arisen that I now need it to be able to return multiple answers.

    So basically at the moment the userform finds the first order number matching the order number entered into the search userform and then fills out the fields to suit.

    On the Changeover Form sheet, the last few order numbers I have changed to 12345678.
    What I would like is when 12345678 is entered into the search userform it returns all 7 entries.
    A maximum of 10 returns should be enough.
    I appreciated I will have to change a lot of things around or even start again, which is fine. I would just like someone to point me in the right direction in how to get started and what is the best way of doing this.

    Any help on this would be much appreciated.

    Kind Regards

    Dan
    Attached Files Attached Files

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

    Re: Modify my SEARCH userform from 1 return to multiple returns if needed?

    Search Button populate ListBox
    Click On Listbox populate textbox

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

  3. #3
    Forum Contributor
    Join Date
    10-25-2016
    Location
    Derby, England
    MS-Off Ver
    MS 2013
    Posts
    228

    Re: Modify my SEARCH userform from 1 return to multiple returns if needed?

    Hi Leo,

    Thank you so much for the modification you have done. Unfortunately it has come up with run time error 9 when I entered the process number 22544880.

    Any chance you could take a look at it please?

    Also if I may be cheeky, there are a couple of other things I'd like to add/change if that is ok?

    If so, I don't need the row number showing in the list box, can I have the date&time instead please and when I press the clear button, can I have it that it clears the list box as well please?

    Thank you again for all you've done, it really is appreciated.

    Kind Regards

    Dan

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

    Re: Modify my SEARCH userform from 1 return to multiple returns if needed?

    With modifications, row numbers still present but not visible
    you need those to polulate textbox

    Kind regards
    Leo
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    10-25-2016
    Location
    Derby, England
    MS-Off Ver
    MS 2013
    Posts
    228

    Re: Modify my SEARCH userform from 1 return to multiple returns if needed?

    Hi Leo,

    Thank you for the changes but there is just one more thing, if that's ok?

    Please can I have the date in the Listbox the same format as the date in the Textbox?

    Thank you again for all you have done.

    Kind Regards

    Dan

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

    Re: Modify my SEARCH userform from 1 return to multiple returns if needed?

    In Code CommandButton1 change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Kind regards
    Leo

  7. #7
    Forum Contributor
    Join Date
    10-25-2016
    Location
    Derby, England
    MS-Off Ver
    MS 2013
    Posts
    228

    Re: Modify my SEARCH userform from 1 return to multiple returns if needed?

    Hi Leo,

    That's brilliant, thank you for all your help.

    Kind Regards
    Dan

+ 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] modify userform search to search the whole wookbook instead of single sheet
    By danbates in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-27-2017, 12:58 PM
  2. Replies: 0
    Last Post: 08-26-2017, 09:25 PM
  3. Replies: 11
    Last Post: 12-15-2014, 01:05 PM
  4. Return multiple values to a UserForm using one search term
    By clapforthewolfman in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-24-2013, 03:37 PM
  5. userform Help (Search, Modify, Delete and Move a Record)
    By anuji.de.silva in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2013, 09:20 AM
  6. [SOLVED] userform Help (Search, Modify, Delete and Move a Record)
    By jason_kelly in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-02-2013, 01:46 PM
  7. Help needed to modify current userform to find and enter corrected data rows
    By LoneWolf3574 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-25-2012, 07:14 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