Since we have entered the correct value, we got the result in the cell. Since we have declared the variable data type as DATE, we cannot store anything other than DATE with an inputbox.Īs soon as you type the date and then click on OK and see what the response is. Now run the code and type other than the date.Ĭlick on ok and see what the response is. In the above example, I have defined the variable as a Variant, which can hold all types of data.įor example, now I have changed the variable type to Date. Note: We can store any value from the inputbox if the variable is defined properly. Let’s run this code now by pressing the F5 key, or you can also run the code manually, as shown in the below screenshot.Īs soon as you run this code, we will see the inputbox.Īs soon as you type the name and click on OK, you will see the inputbox value in cell A1. I = InputBox('Please Enter Your Name', 'Personal Information', 'Type Here') So for this, write the code as Range (“A1”).Value = i Step 3: Now, whatever the value typed in the input box, we need to store it in cell A1.

Note: Once the input box comes to the right of the equal sign, we need to enter the arguments or syntax in brackets like our regular formulas.

Step 2: For this variable, assign the value through the inputbox.ĭim i As Variant i = InputBox('Please Enter Your Name', 'Personal Information', 'Type Here') End Sub Step 1: Declaring the variable as Variant. Now we will go through the process of storing values in cells. Run this code and see your first input box. Step 7: Type the default value as “Type here.” Step 6: Type the Title of the inputbox as “Personal Information.” Step 5: Give the prompt as “Please Enter Your Name.” Step 4: Select the inputbox and give space, and you will see the syntax of the inputbox.

Excel vba open for input as