Visual Basic for Applications Reference
 
InStr Function
       
 
Returns a Variant (Long) specifying the position of the first occurrence of one string within another.
 
Syntax
 
InStr([start, ]string1, string2[, compare])
 
The InStr function syntax has these arguments:
 
Part Description  
start Optional. Numeric expression that sets the starting position for each search. If omitted, search begins at the first character position. If start contains Null, an error occurs. The start argument is required if compare is specified.  
string1 Required. String expression being searched.  
string2 Required. String expression sought.  
compare Optional. Specifies the type of string comparison. If compare is Null, an error occurs. If compare is omitted, the Option Compare setting determines the type of comparison. Specify a valid LCID (LocaleID) to use locale-specific rules in the comparison.  
 
 
Settings
 
The compare argument settings are:
 
Constant Value Description  
vbUseCompareOption -1 Performs a comparison using the setting of the Option Compare statement.  
vbBinaryCompare 0 Performs a binary comparison.  
vbTextCompare 1 Performs a textual comparison.  
vbDatabaseCompare 2 Microsoft Access only. Performs a comparison based on information in your database.  
 
 
Return Values
 
If InStr returns  
string1 is zero-length 0  
string1 is Null Null  
string2 is zero-length start  
string2 is Null Null  
string2 is not found 0  
string2 is found within string1  Position at which match is found  
start > string2 0  
 
 
Remarks
 
The InStrB function is used with byte data contained in a string. Instead of returning the character position of the first occurrence of one string within another, InStrB returns the byte position.
 
 
--------------------------------------------------------------------------------
Send feedback to MSDN.Look here for MSDN Online resources.

 
Visual Basic for Applications Reference
 
Mid Function
       
 
Returns a Variant (String) containing a specified number of characters from a string.
 
Syntax
 
Mid(string, start[, length])
 
The Mid function syntax has these named arguments:
 
Part Description  
string Required. String expression from which characters are returned. If string contains Null, Null is returned.  
start Required; Long. Character position in string at which the part to be taken begins. If start is greater than the number of characters in string, Mid returns a zero-length string ("" ).  
length Optional; Variant (Long). Number of characters to return. If omitted or if there are fewer than length characters in the text (including the character at start), all characters from the start position to the end of the string are returned.  
 
 
Remarks
 
To determine the number of characters in string, use the Len function.
 
Note   Use the MidB function with byte data contained in a string, as in double-byte character set languages. Instead of specifying the number of characters, the arguments specify numbers of bytes. For sample code that uses MidB, see the second example in the example topic.
 
 
--------------------------------------------------------------------------------
Send feedback to MSDN.Look here for MSDN Online resources.