How to Rotate Spin Button in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

If you want to rotate spin button in Excel, you have come to the right place. Here, we will walk you through 4 easy steps to do the task smoothly.


What Is Spin Button?

A Spin Button allows you to easily increase or decrease a value, like incrementing a number, date, or time. By clicking the up arrow, the value can be increased; by clicking the down arrow, it can be decreased. One can use them to avoid clicking inside a cell and typing a number.

Special Note:

Before going to the article, let us remind you that we have two forms of Spin Buttons in Excel. They can be found in the Developer tab, under the Insert group. The Spin Button presented in the Form Control group can be assigned directly to a cell. However, we cannot rotate them. On the other hand, Spin Button presented in the ActiveX Control group can be rotated. However, they need VBA to assign to a cell. In this article, we will show you how you can rotate a Spin Button that is presented in the ActiveX Control group.

Read More: How to Use Spin Button in Excel


Step-by-Step Procedures to Rotate Spin Button in Excel

In the following article, we will describe 4 easy steps to rotate spin button in Excel.

Here, we use Excel 365. You can use any available Excel version.


Step-1: Making Dataset

Before inserting a Spin Button, and rotating it, we have created the following dataset. In the dataset, you can see the values for Monthly Salary and Additional Monthly Earnings. Next, we will find out the Yearly Earnings.

Making Datatset to Rotate Spin Button Excel

  • Afterward, to find out Yearly Earnings, we will use the following formula in cell C6.
=(C4*12)+(C5*12)

  • At this point, press ENTER.
  • Therefore, you can see the result in cell C6.
  • After that, we will insert a Spin Button and assign it to cell C5, so that every time we click on the spin button, the value of C5 will change. Also, the value of cell Yearly Earnings will also change.


Step-2: Inserting Spin Button from Form Control

In this step, we will insert Spin Button.

  • In the first place, go to the Developer tab >> click on Insert.
  • Then, from the ActiveX Control group >> click on the Spin Button that is marked with a red color box.

Inserting Spin Button to Rotate Spin Button Excel

  • After that, we place the Spin Button beside our dataset.


Step-3: Rotating Spin Button

In this step, we will demonstrate how you can rotate a Spin Button.

  • To do so, first, click on the Spin Button, therefore you will see a dragging arrow at the right-bottom corner of the Spin Button.
  • Drag the Spin Button with this arrow and rotate it.
  • Note: You can rotate the Spin Button to a horizontal or a vertical position.

Dragging Spin Button to Rotate Spin Button Excel

  • Hence, we rotate the Spin Button.

  • For a better understanding, look at the following GIF.


Step-4: Inserting VBA Code

Now it’s time to assign a code to the Spin Button so that every time we click on a button, the value of the dataset changes. Here, we want to change the value of cell C5 through Spin Button.

  • To do so, in the beginning, we will right-click on the Spin Button.
  • Then, from the Context Menu >> select View Code.

Applying VBA to Rotate Spin Button Excel

  • At this point, a VBA Editor window will appear.
  • Then, we will type the following code in the VBA Editor window.
Private Sub SpinButton1_SpinUp()
   With Range("C5")
    .Value = WorksheetFunction.Min(1000, .Value + 50)
 End With
End Sub
Private Sub SpinButton1_SpinDown()
  With Range("C5")
       .Value = WorksheetFunction.Max(300, .Value - 50)
     End With
End Sub

  • Then, we will Save the code >> Run the code.

  • Then, we will return back to our Worksheet.
  • After that, click on the Spin Button, and you can see the change in cell C5 every time we click on the Spin Button.
  • Along with that, you can see the change in Yearly Earnings.

Read More: How to Control Multiple Cells with Spin Button in Excel


Download Workbook

You can download the following Excel file and practice while reading this article.


Conclusion

Here, we show you 4 easy steps to rotate spin button in Excel. Thank you for reading this article. We hope it was helpful. If you have any queries, please let us know in the comment section.


Related Articles

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo