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 SpinButton to a UserForm

Add a SpinButton to a UserForm - Microsoft Excel Tutorial

From the course: Excel VBA: Managing Files and Data

Start my 1-month free trial

Add a SpinButton to a UserForm

“

- One very handy control, that allows users to increase or decrease values in a user form, is a spin control. Spin controls have two buttons. An Up arrow button that increases the value and a Down arrow button, that decreases it. In this movie, I will show you how to create a spin control and display its value in a text box. My sample file is 0607 spin button, and you can find it in the chapter six folder of the exercise files collection. We're not going to work with any worksheet data. So I'll press Alt F +11 to move to the Visual Basic Editor. In here I have a user form set up and ready to go. To define a spin control, I need to work with the toolbox which is displayed here on the left. If for some reason the toolbox isn't visible. For example, if got closed by accident, you can make sure the user form is selected, and then go up to the menu bar and click the toolbox button and it will reappear. Now…

Contents