Using range.find to find two specific values in two columns

Hello,

I have been trying to get the code below to work for a while now and am pretty much stuck.

What I have made is a userform that the user inputs a job # and seq # (columns A and B), and it will search for those two user values and print out columns A B C D into the userform BOX.

I have gotten this to work by only using one of the values (JOB) , however I am stumped as to how to search another column (column B) to get the row that has that JOB AND SEQ.

For example, here is how the table will look:

JOB SEQ MACHINE 1 MACHINE 2
100 202 MAT MAT
100 204 MAT MAT

I want the user to type in

JOB : 100
SEQ 202

and see in the box

100 202 MAT MAT


Here is what I have so far:

Please Login or Register  to view this content.

Thanks for anyones help

Mike,

Thank you VERY MUCH! That is exactly what I wanted to do and it works very nicely.

Thanks for the quick reply as well!

-Mike