VBA Code to see if criteria in a user form matches to a row in a table

[dbkimber]

I'm trying to use a form to match criteria in entered in a user form to a row in a table. If box1 value is found in the table and the value in box2 if found in the cell to the right of the value in box1 and the value in box3 is found in the same row as the first two boxes values, then I want to load the value in box4 to specific place in a sheet. if something doesn't match i want to have a message box pop up saying something doesn't match.

 

[dbkimber]

working of a work computer that blocks any downloads the table i pasted is the the table im working off of. i can paste the code as ive adjusted it in here along with
a screen shot of the user form im building

Private Sub CommandButton1_Click()
  Dim r As Range, f As Range, exists As Boolean, cell As String
 
  Set r = Range("Master[[#All],[Cert 1]:[Cert 16]]")
  Set f = r.find(cmbcrt.Value, , xlValues, xlWhole)
  If Not f Is Nothing Then
    cell = f.Address
    Do
      If Range("F" & f.Row) = cmbsign And Range("G" & f.Row) = codbx Then
        exists = True
        'it would perform a task
        Exit Do
      End If
      Set f = r.FindNext(f)
    Loop While Not f Is Nothing And f.Address <> cell
  End If
 
  If exists = False Then MsgBox "Your code does not match or you don't hold and active cert for that book. Please check the information entered."
End Sub

Signer would be cmbsign  (been referring to as box1)
Authorization code is (codbx been referring to as box2)
Cert Book is cmbcrt (been referring to as box3)
[ATTACH type="full"]8093[/ATTACH]

 

[dbkimber]

Signer would be cmbsign (been referring to as box1)
Authorization code is (codbx been referring to as box2)
Cert Book is cmbcrt (been referring to as box3)


the above isn't supposed to be in the code part of the reply

 

[DanteAmor]

The macro works for me.

You can put a sample of your data where you can see the names of the columns. Use xl2bb tool.

Please provide a sample of your data with which you are testing.