Spin Button Vba. You can write code that uses the spinbutton to update the displayed value of another control. This control is used in conjunction with some other control to increase decrease value.
Right click the spin button make sure design mode is selected. We will first see how to set properties of a spin button in vba and get a value in worksheet. You will notice that by default the lowest value we can reach is 0 with the highest value being 100.
Set a spin button using vba.
Now drag the place where you want to place that button and re size as per your requirement. Drag a spin button on your worksheet. In the activex controls group click spin button. Set the spinbutton min max and current value.
