Min and Max limits on Spin Button (userform)

You have already set the correct limits in the attributes of the spin button in its Properties list. However, I can't figure out what you want to do when the spin button is clicked. Your code does not actually refer to the value of the spin button anywhere. Instead you are adjusting the value of a cell by adding or subtracting 0.05 (5%) when the spin button is clicked up or down, respectively.

I would suggest that you make the attribute SmallChange = to 5, and then change your code to:

Please Login or Register  to view this content.

Now when you click the button, the cell will have the same value as the spin button, converted to a percentage.