Input Box

The InputBox function is a basic interface requesting input from the user before the program can continue. You can configure the prompt, the title for the window, a default value, the window position, and user help files. Only two buttons are provided: OK and Cancel. The returned value is a string. The following code asks the user for the number of months to be averaged. The resulting InputBox is shown in Figure 9.1.

AveMonths = InputBox( _

"Enter the number of " & _ "months to average", _ "Enter Months", "3")

0 0

Post a comment