View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bartman1980 bartman1980 is offline
external usenet poster
 
Posts: 34
Default 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!