+ Reply to Thread
Results 1 to 3 of 3

Listbox filtering results

  1. #1
    Registered User
    Join Date
    01-27-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    30

    Listbox filtering results

    I am trying to create a userform that allows the user to type in or click a reference or claim number into the combobox (labeled Userfilter) and it will filter all the rows in the listbox with that claim number. the results show a date of different issues for that specific claim number. once a date is clicked, all the fields in the multipage fill with the different information from that row.

    the problem i am having is that the fields fill from the top to bottom of the excel sheet, no matter what is being clicked on in the listbox. So, even though you are looking for Bob's claim, with two dates showing in the listbox, it will always show the very first two rows of the excel sheet.

    I'm very lost as to what i would need to do to correct this. please help . thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-27-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Listbox filtering results

    Bump - no response

  3. #3
    Registered User
    Join Date
    01-27-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Listbox filtering results

    Sorry, I've also posted up the excel sheet in case that's easier to upload.
    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)

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