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 7-2.
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.

Figure 7-2. An InputBox dialog box
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 this 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