From the course: Excel VBA: Managing Files and Data

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Add a TextBox to a UserForm

Add a TextBox to a UserForm - Microsoft Excel Tutorial

From the course: Excel VBA: Managing Files and Data

Start my 1-month free trial

Add a TextBox to a UserForm

“

- There are many different controls that you can add to a user form to allow user input. In this movie, I will show you how to add a TextBox, which allows users to type in text that you would then transfer to a worksheet. My sample file is 0602 text box, and that's a macro enabled workbook you can find in the chapter six folder of the exercise files collection. We won't work with any of the worksheet data. So I'll press Alt + F11 to move to the visual basic editor. And here you that I have a user form already created, and the toolbox is visible on the left. If you don't see the toolbox, which is this box here, you can go up to the control bar and click the toolbox button. You could also go to view and click toolbox to display it. In this case, I want to add a TextBox from the toolbox, so I'll go down and activate the toolbox and click the text box control. Once I've selected the TextBox button, I can go onto the…

Contents