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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access