The VBE will present the following code: Private Sub SpinButton1_Change() In the right Dropdown menu select Change.In the left Dropdown menu select SpinButton.To add functionality when the rotation bar is changed you need a specific Event Sub ( Private Sub SpinButton1_Change()): In our example we will have three button events: Private Sub CommandButton1_Click(), Private Sub CommandButton2_Click() and Private Sub CommandButton3_Click(). You must create events for each of the buttons on the UserForm. The CommandButton1 option in the left Dropdown only will be found if the command button ( ) has already been previously added to your UserForm and its property ( Name) has not been changed. The VBE will present the following code: Private Sub CommandButton1_Click() In the right Dropdown menu select Click.In the left Dropdown menu select CommandButton.Right-click the UserForm (Project Explorer).To create an event when there is a click (in the view mode) on the command button ( Private Sub CommandButton1_Click()): We also need to establish a relationship between the data entered, the form and the worksheet.Д¬reating events for control buttons is similar to what was done for the UserForm_Inicialize(). In the example we are developing, related to the Userform Layout and the Userform Events, we still need to configure the command buttons and the UserForm spin button. One of the great advantages of the Userform is its interaction with Excel spreadsheets, giving it dynamism and a differentiated interface.

Spin button excel vba code