Search data then show results in a list box

[kira023]

Hi,

I'm currently working on a troubleshooting guide for our team and I've created a userform to be able to search using the 2 combo boxes that are dependent with each other. When clicking the Search button I wanted it to use the information on the 2 combo boxes to find it in a single worksheet where all the data is located (eg. Bot Names = column B and automation name = column C) and then show the troubleshooting guide in column D on a list box which corresponds to the data being searched by the 2 combo boxes.

I don't have an initial code for the search button. If someone can please help me create this that would be helpful.

Thank you

 

[Fluff]

As I said before if you have multiple rows that match both Combos 1 & 2, then using a textbox won't work.

If you can upload a new sample workbook, with data that accurately represents your real data, then I will have a look at it.