Open the Properties Window (F4 key, or right-click the
Spin Button and select Properties from the menu) and set
the Min to 1 and Max to 25.

-----Original Message-----
Hi All,

I have a spinn button on a user form and a text box

When I press Up the text box value will be text box value
+1 and Down makes text box value - 1

how can I limit the maximum to 25 and minimum to 1?

TIA
Soniya
.