The InputBox Function
The InputBox
function is designed to get input from
the user. The most commonly used (but not the complete) syntax is:
InputBox(prompt
[,title
] [,default
])
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.
Get Access Database Design and Programming, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.