substring matching functions (need a hand please)

[Ciccio_Drink]

Hi all, I am a very new Excel macro functions user.

I was looking for a function able to check if a substring is or not present in another string.

i.e. if the string "--------AB-------" contains the string "AB"

sorry for the newbie question and thx all

[Ciccio_Drink]

I just found the answer

function InStr ( "String1", "String2" )

[Norman Jones]

Hi Ciccio_Drink,

Look at the InStr function in VBA help:

'=============>>
Public Sub Tester001()
Dim sStr As String

sStr = " A horse, my Kingdom for a horse"

If InStr(1, sStr, "xhorse", vbTextCompare) > 0 Then _
MsgBox "substring found!"

End Sub
'<<=============


---
Regards,
Norman



"Ciccio_Drink" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi all, I am a very new Excel macro functions user.
>
> I was looking for a function able to check if a substring is or not
> present in another string.
>
> i.e. if the string "--------AB-------" contains the string "AB"
>
> sorry for the newbie question and thx all
>
>
> --
> Ciccio_Drink
> ------------------------------------------------------------------------
> Ciccio_Drink's Profile:
> http://www.excelforum.com/member.php...o&userid=31003
> View this thread: http://www.excelforum.com/showthread...hreadid=506710
>

[Norman Jones]

Hi Ciccio_Drink,

To see the message, replace "xhorse" with "horse"

---
Regards,
Norman



"Norman Jones" <[email protected]> wrote in message
news:[email protected]...
> Hi Ciccio_Drink,
>
> Look at the InStr function in VBA help:
>
> '=============>>
> Public Sub Tester001()
> Dim sStr As String
>
> sStr = " A horse, my Kingdom for a horse"
>
> If InStr(1, sStr, "xhorse", vbTextCompare) > 0 Then _
> MsgBox "substring found!"
>
> End Sub
> '<<=============
>
>
> ---
> Regards,
> Norman

[Ciccio_Drink]

thank you very much Norman,

Ciccio