partnumber search and select the cell
 

I have a list of partnumbers in column A.
This partnumbers can be numbers and/of letters.
Example: Cell A22 contains 123ABC

My fill-in cell to find partnumbers is B1, next to that cell is a
button called "search partnumber".
When I 123 in B1 he should select cell A22.
But if I want to find 3ABC, he also has to select A22.

If I click again on "search partnumber" then he has to find all the
other partnumber containing 3ABC.

I know how to get the CTRL-F screen, but I don''t want this.

Thanks in advance for your help!

partnumber search and select the cell
 

Look in the vba help index for FIND or record a macro while doing it
manually. Then incorporate into a worksheet_change event in the worksheet
code. To get there right click sheet tabview code

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bartman1980" wrote in message
ps.com...
I have a list of partnumbers in column A.
This partnumbers can be numbers and/of letters.
Example: Cell A22 contains 123ABC

My fill-in cell to find partnumbers is B1, next to that cell is a
button called "search partnumber".
When I 123 in B1 he should select cell A22.
But if I want to find 3ABC, he also has to select A22.

If I click again on "search partnumber" then he has to find all the
other partnumber containing 3ABC.

I know how to get the CTRL-F screen, but I don''t want this.

Thanks in advance for your help!