Visual Basic – String
Functions
IETI College - Alabang
The Mid Function
The Mid Function is used to retrieve a part of text
from a given phrases. The syntax is:
Mid(phrase, position, n)
Phrase is the string from which part of the text is
to retrieved
Position is the starting position of the phrase from
which the retrieving process begins. n is the
number of characters to be retrieve.
The Right Function
The Right function extracts the right portion of a
phrase. The syntax is
Microsoft.Visualbasic.Right ("Phrase", n) Where n
is the starting position from the right of the phase
where the portion of the phrase is going to be
extracted.
The Left Function
The Left function extracts the left portion of a
phrase. The syntax is:
Microsoft.Visualbasic.Left("Phrase", n) Where n is
the starting position from the left of the phase
where the portion of the phrase is going to be
extracted.
The Trim Function
The Trim function trims the empty spaces on both
sides of the phrase. The format is
Trim("Phrase")
The MsgBox Function
The objective of MsgBox is to produce a pop-up
message box and prompts the user to click on a
command button before he or she can continues.
This syntax is as follows:
yourMsg=MsgBox(Prompt, Style Value, Title)
The MsgBox Function
Style Value Named Constant Buttons Displayed
0 vbOkOnly Ok button
1 vbOkCancel Ok and Cancel buttons
Abort, Retry and Ignore
2 vbAbortRetryIgnore
buttons.
Yes, No and Cancel
3 vbYesNoCancel
buttons
4 vbYesNo Yes and No buttons
5 vbRetryCancel Retry and Cancel buttons
The MsgBox Function
Value Named Constant Button Clicked
1 vbOk Ok button
2 vbCancel> Cancel button
3 vbAbort Abort button
4 vbRetry Retry button
5 vbIgnore Ignore button
6 vbYes Yes button
7 vbNo No button
The InputBox Function
An InputBox( ) function will display a message box
where the user can enter a value or a message in
the form of text.
The syntax to call up an Input Box is
Microsoft.VisualBasic.InputBox(Prompt, Title,
default_text, x-position, y-position)
