Trying to get the row number

I am very new to VBA.

I have a simple user form that has a couple of drop down boxes. The drop down boxes are limited by the date and the second one is dynamic off the first.

My question is that once the two selections are made I need to know what row the values are on. Or a way to count down to that row?

Hope this makes sense.

Please Login or Register  to view this content.

I think this is what you are after:

Please Login or Register  to view this content.

MGS73 - Thank you for the response. I do not think that is what I want or at least I do not know how to get the result I am looking for with it.

Perhaps this is an easier way of asking the question.

Please Login or Register  to view this content.

The above code works and gives me the one answer I am looking for. But I also need the row number the answer is found on. It is in the Items Item list but I cannot figure out how to get it to tell me the row number when it finds the answer.

All help is greatly appreciated.

A sample workbook would make life a lot easier to provide a solution

Thank you Bakerman2. That works wonderfully.