Search
 

Hello,

I am stuck and cannot remember how to do this...

I would like to perform an if statement that:

if (the current cell has a "C" character somewhere within it) then
........Perform an action......
elseif (it does not) then
..........perform another action.......
endif

What statement do I need to use to determine if a "C" is a character
anywhere in the cell. I remember how to use the Left, Right and Mid
functions, but I cannot remember how to use the Search function in this
manner. What would be the best way to go about doing this?

Thank You,

Search
 

Hi,
Try this :

Sub test()

Dim stringtosearch As String
Dim stringtofind As String

stringtosearch = "ABCDEFG"
stringtofind = "C"

If InStr(1, stringtosearch, stringtofind) < 0 Then
MsgBox "C found" ' Add found logic.....
Else
MsgBox "C not found" ' Add not found logic ....
End
End If

End Sub

HTH

"tjh" wrote:

Hello,

I am stuck and cannot remember how to do this...

I would like to perform an if statement that:

if (the current cell has a "C" character somewhere within it) then
.......Perform an action......
elseif (it does not) then
.........perform another action.......
endif

What statement do I need to use to determine if a "C" is a character
anywhere in the cell. I remember how to use the Left, Right and Mid
functions, but I cannot remember how to use the Search function in this
manner. What would be the best way to go about doing this?

Thank You,