Im not sure if this is even possible but i'll give it a try.
Is there a way in VBA to code to find an exact match(s) based on the value of a combobox on a userform(user selects the value of the combobox), then based on that value, find an exact match or matches that may occur in the same column? If this much is possible then can VBA be coded to look at all the rows where the match or matches occured, and list selected data from other cells IN THE SAME ROW in a listbox?
Based on the table below: The user chooses "234" in the combobox dropdown.
At that point, Id like the listbox to only show the duplicates of the 3 rows and 5 columns where "234" occured in the first column.
Possible?? I guess we'll see.
[TABLE="class: grid, width: 300"]
[tr][td]234
[/td][td]1
[/td][td]6
[/td][td]6
[/td][td]4
[/td][/tr][tr][td]345
[/td][td]2
[/td][td]6
[/td][td]3
[/td][td]9
[/td][/tr][tr][td]456
[/td][td]4
[/td][td]1
[/td][td]1
[/td][td]7
[/td][/tr][tr][td]678
[/td][td]5
[/td][td]2
[/td][td]2
[/td][td]8
[/td][/tr][tr][td]234
[/td][td]6
[/td][td]3
[/td][td]3
[/td][td]1
[/td][/tr][tr][td]234
[/td][td]7
[/td][td]7
[/td][td]2
[/td][td]2
[/td][/tr][tr][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/TABLE]