Databases Reference
In-Depth Information
where
prompt
is the message in the input box,
title
is the title for the input box, and
default
is the default value that is displayed in the text box. For instance, the code:
sName = InputBox("Enter your name.", "Name", "Albert")
produces the dialog box in Figure 12-2.
Figure 12-2. An InputBox dialog box
The
InputBox
function returns the string that the user enters into the text box. Thus, in our
example, the string variable
sName
will contain this string.
Note that if we want a number from the user, we can still use the
InputBox
function and
simply convert the returned string (such as
"12.55"
) to a number (12.55) using the
Val
function, discussed later in the chapter.
12.3 VBA String Functions
Here are a handful of useful functions that apply to strings (both constants and variables):
The
Len
function
The
Len
function returns the length of a string, that is, the number of characters in
the string. Thus, the code:
Len("January Invoice")
returns the number 15.
The
UCase
and
LCase
functions
These functions return an all-uppercase or all-lowercase version of the string
argument. The syntax is:
UCase(
string
)
LCase(
string
)
For instance: