Creating Search Macro

Hi,

I am writing a macro to search the range A1:A70 on all worksheets in a workbook. The macro will pull up an input box for a user to type in a part number and should find the location of the part number in its corresponding worksheet.

The code I have so far looks like this...
--

Please Login or Register  to view this content.

--

Does any of this look correct at all? I'd really appreciate the help. Thanks.

You need to edit your post and put code tags around the code before anyone will be allowed to comment on it.
To do that select [Edit] -> [Go Advanced], then select your code, and click the [Code] button.

Yes that fixed it

The code looks 'ok', I'm guessing it is from an example found elsewhere?
Is the partnumber the only thing in the cell where it is located, or is there other text in the same cell?
Will there only ever be one match of the partnumber?
If there are multiple matches possible, then do you just want the first one presented?
Once the macro has found the part number in the sheet what is it to do with it? (A message box, or are you doing further processing in your macro based on it?)

I would prefer it to bring the user to the corresponding location, but if this is not feasible, returning the cell address would be appropriate. The code is part of an example found elsewhere but I've modified a little bit.

The part number is the only thing located in the cell and there would most likely not be multiples. In the event of multiple matches, the first should be presented.

Thanks for your help!

This should do what you want:

Please Login or Register  to view this content.

If you have any questions please do ask