Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The user wants to find a record on a list. He enters a PO#, and it
searches the list. Example. User enters in M123456. The list contains this number, but also has M123456A, M123456B and M123456C. The userform comes up showing the 1st record, M123456. The code below is in the useform, and it counts the number of records with the PO#, plus variations at the end of the PO#. In the above example, Texbox 25 will show the number 4. This works fine. CountPO = Application.CountIf(Range("POCurrent_Column"), FindPOVal & "*") TextBox25.Value = CountPO What I want is to narrow it down to cause the wildcard in the above code (FindPOVal & "*") to only look for alpha characters at the end of the value FindPOVal. So, if M123456 and M123456A, M123456B and M123456C are on the list, textbox 25 will correctly show the number 4. BUT, if for some reason there is also M123456789 on the list, it won't be counted, and textbox 25 will still show the number 4. Thanks, J.O. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search list for non-alpha characters | Excel Worksheet Functions | |||
WILDCARD CHARACTERS | Excel Programming | |||
Writing A Search Macro With Wildcard Characters? | Excel Programming | |||
wildcard characters | Excel Discussion (Misc queries) | |||
Wildcard for ALPHA only | Excel Discussion (Misc queries) |