spin button in excel

[roofi]

Hello all,
I use spin button in excel for autonumbering. but it couts upto 30000 what if i want to count further on?
on inputting a higher value it will throw up an error message. but i want to count above 30000
responder will definitely appreciated.
thanks

[Ace_XL]

-- Right click on the 'spin button'
--Format control -- control
As you can see 'maximum value' allowed is 30000

on inputting a higher value it will throw up an error message

[akhileshgs]

You can do this by following this post