Find the value of a cell....

Afternoon, All.

How would I code to find the value of a particular cell? For example, a part number is entered into a cell on one worksheet, and the user clicks a button to find that part on another sheet.

Here is what I have, but I get an error:

Please Login or Register  to view this content.

Thanks in advance for any help.

Hutch

Please Login or Register  to view this content.

S'up, Roy.

I got confused. I was entering as a formula syntax rather than a VBA syntax, (I think).

Thanks for the help, guys.

Hutch