Wildcard

[Guest]

Hi i have some code where one line is if a cells value = "ABC" then do something. sometimes however it may be ABC inc or ABC corp. The help function wasn't clear on how to search for ABC*. what is the correct syntax pls

Thk

 

[Bob Flanagan]

One way to check a cell entry for a string is:

If instr(activecell.value, "ABC") > 0 then
'do something
End if

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

Hi i have some code where one line is if a cells value = "ABC" then do

something. sometimes however it may be ABC inc or ABC corp. The help
function wasn't clear on how to search for ABC*. what is the correct syntax
pls.

 

[Nigel]

If you know the string always starts ABC then you could use

IF LEFT(cell,3) = "ABC" then

or use trim to remove any spurious spaces at the start eg

IF TRIM(LEFT(cell,3)) = "ABC" then

you might like to fix the lower case problem of Abc or ABc etc.....

IF UPPER(TRIM(LEFT(cell,3))) = "ABC" then

Cheers
Nigel

Hi i have some code where one line is if a cells value = "ABC" then do

something. sometimes however it may be ABC inc or ABC corp. The help
function wasn't clear on how to search for ABC*. what is the correct syntax
pls.

 

[Don Guillett]

You might "like" this. It will pick up abc wherever in the cell.

Sub likeabc()
If UCase(ActiveCell) Like "*ABC*" Then MsgBox "HI"
End Sub

--
Don Guillett
SalesAid Software
(e-mail address removed)

Hi i have some code where one line is if a cells value = "ABC" then do

something. sometimes however it may be ABC inc or ABC corp. The help
function wasn't clear on how to search for ABC*. what is the correct syntax
pls.