VB & VBA in a Nutshell: The Language

Mid, Mid$, MidB, MidB$ Functions

Named Arguments

Yes

Syntax

Mid(string, start[, length])

string

Use: Required

Data Type: String

The expression from which to return a substring.

start

Use: Required

Data Type: Long

The starting position of the substring.

length

Use: Optional

Data Type: Variant (Long)

The length of the substring.

Return Value

A Variant of subtype String or a String data type.

Description

Returns a substring of a specified length from within a given string.

Rules at a Glance

• If string contains a Null, Mid returns Null.

• If start is more than the length of string, a zero-length string is returned.

• If start is less than zero, runtime error 5, "Invalid procedure call or argument," is generated.

• If length is omitted, or length is greater than the length of string, all characters from start to the end of string are returned.

• The MidB version of the Mid function is used with byte data held within a string. When using MidB, both start and length refer to numbers of bytes as opposed to numbers of characters.

Example

The following example parses the contents of a text box control (named txtString) and writes each word to a list box (named lstWord ). Note the use of the InStr function to determine the position of either a space or a carriage return/linefeed character combination, the two characters that can terminate a word in this case:

Private Sub cmdParse_Click() Dim strString As String, strWord As String Dim intStart As Integer, intEnd As Integer Dim intStrLen As Integer, ...