Coding for Input Box Search ...

Hi, could someone give me a code that will allow text box input to be
searched for a match on all worksheets in location D17 of all worksheets?

Example: Please Enter Your Search Name: James

James would be searched for on all worksheets in cell D17, The first Sheet
That Finds James at D17 becomes active sheet.

Thanks For any Assistance On This..

See if this will work for you:

Please Login or Register  to view this content.

Ah, yes, more efficient, and takes into account upper/lower case and if cancel is selected. Very good.

Hey, Thanks Alot for the Codes!

I am getting a run-time 1004 error with your code mudraker. It reads:

'Activate Method of Range Class Failed'

It only does it if the input is Found... But works if the input isn't found..

This is what is hilighted: wS.Range("d17").Activate

Thanks.