在Excel VBA 2013中的选择语句中使用通配符

As a beginner I am having trouble with syntax in VBA. The Select statement as written below does not execute the way I thought it should. It has to do with the use of the wildcard. If I default to a specific case (SAY "FA00001") it flows correctly. When I use the wild card every Part number falls in to the last case. As a beginner I am having trouble with syntax i