How to Create an Input Box in Excel VBA

Video Transcript

"Hi my name is Dave Andrews and today I am going to show you how to create an input box in Excel VBA. Let's open up Excel by clicking on the start button and going to all programs, office, and Excel. Now we need to open up the Excel VBA and to do that hold down the All key on your keyboard, press F11. This opens up the VB editor and what we want to do is go to the top and select insert, select user form. This pulls up the new form for us to drop what are called controls on. The control that we want is the text box and so just grab the text box and just drag it right there on to our form. Now that we have our form created we need to have some way for that form to be shown from Excel. So close the VBA and insert some kind of object I'm just going to say picture so find a picture and there, there is our object that is going to set off this user form. To cause it to do so we want to right click on the picture and say assign macro and now with the assigned macro window say new which opens up our VBA again and we want to say user form 1.show. Now we can close the VBA and click off of that picture and now as you can see my hand, my little cursor is a hand and if I click on that picture there is my user form and my info box. My name is Dave Andrews and I have just showed you how to create an input box using Excel VBA."