Add one more criterion in Combo box.

Please help me, the below code helps me to retrieve the information from a small database based on textbox2, Can you help me to add another criteria on combobox2 which will give me a list by lookup from column C then populate the information on userform

for eg:

case101 has 2 files namely A & B

when i do the search on case101 the dropdown gives me the option to choose AorB and when I select A it populates the information on the userform.

I have got this far but not able to populate through dropdown..

I highly appreciate your kind help in advance

Aji

Private Sub CommandButton1_Click()
row_number = 0
Do
DoEvents
row_number = row_number + 1
item_in_review = Sheets("Sheet1").Range("B" & row_number)
If item_in_review = TextBox2.Text Then
TextBox1.Text = Sheets("Sheet1").Range("D" & row_number)
TextBox4.Text = Sheets("Sheet1").Range("E" & row_number)
ComboBox1.Text = Sheets("Sheet1").Range("F" & row_number)
TextBox3.Text = Sheets("Sheet1").Range("G" & row_number)


Loop Until item_in_review = ""

End Sub

Moderator Note:

Pls use code tags around your code next time as per forum rules.