Bhavin

• Oct 18th, 2016

Simplest Answer ever :

Code
Simplest answer ever: 
Dim objString
objString = "This is the string"
 
Dim objFound
objFound = "the string"
 
if Instr (objStr, objFound) Then
    msgbox "String found"
Else
     msgbox "String not found"
End If

sneha

• Mar 4th, 2015

Code
Dim StringValue="Country"
SubstringValue=mid(StringValue,2,4)
 
msgbox SubstringValue
 
Returns Substring from starting position  2 and 4 character following
 
Returns "ount"
 

Answer Question  Select Best Answer