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
Bookmarks