Enter data in text box and go the cell containing that text

[richardcarter]

I have a very long spreadsheet with about 3000 rows. lets say for simplicity that column A contains a list of product ID numbers. I am looking for some macro code where I can just type in the product ID into a textbox, then hit enter (or a 'go' button) and then the cursor will move to the cell containing the part number.

I know Ctrl+F will do the job for me, but because of the frequency that I do these searches, a text input box would be easier still.

The nearest solution I could find was the one here http://www.mrexcel.com/forum/showthread.php?t=23469&page=3 but its a bit 'overkill' for my needs.

Would welcome any suggestions. Many thanks.

 

[richardcarter]

Sorry - I meant to say "then the cursor will move to the cell containing the product number".