InputBox Function

You can use the InputBox function in Excel VBA to prompt the user to enter a value. Place a command button on your worksheet and add the following code lines:

1. First, declare the variable myValue of type Variant.

Note: we use a variable of type Variant here because a Variant variable can hold any type of value. This way the user can enter text, numbers, etc.

2. Add the following code line to show the input box.

3. Write the value of myValue to cell A1.

Result when the user enters the value 5 and clicks the OK button.

4. The InputBox function has more optional arguments. The following code line shows an input box with a title displayed in the title bar and has a default value. The default value will be used if no other input is provided.

Result when the user only clicks the OK button.

Note: Place your cursor on InputBox in the Visual Basic Editor and click F1 for help on the other optional arguments.