Is there a way to put the row number on a value found on a worksheet into a textbox?

So let's say I have a worksheet with a column filled with phone numbers. I have a userform with a text box that I will be typing in a phone number into, and I want a different text box to reflect the number of the row that the phone number is found in on the worksheet.

I've looked around, but all the codes I've seen people write are very specific to their needs and much different from another.

Found a solution that worked!

Please Login or Register  to view this content.

Yet another solution.

Code in the form module:

Please Login or Register  to view this content.

Artik