Return values from three combo box's

[Aussie_Excel_Wanna_Be]

Hello All,

I am trying to return multiple values based on information in three combo box's. When I run the code I only get the values returned on the first two combo boxes as it looks for the first model which fits two critera but doesn't pick up the third? Any help would be greatly appreciated. You can see the couple of ways I have tried to get it to work.... haha!

Thanks

Glenn

Code:

With Sheets("H_B_SERV_PARTS")
For irow1 = 2 To .Range("A65536").End(xlUp).Row
If Worksheets("H_B_SERV_PARTS").Cells(irow1, 2).Value = Me.ComboBox2.Value Then
'If Worksheets("H_B_SERV_PARTS").Cells(irow1, 2).Value = Me.ComboBox2.Value And 'Worksheets("H_B_SERV_PARTS").Cells(irow1, 38).Value = Me.ComboBox3.Value Then

 

[davesexcel]

Your code is only using 2 comboboxes