On a userform?

Me.SpinButton2.Maximum = Me.SpinButton1.Maximum + 1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Brad" wrote in message
...
I posted a question yesterday labelled (Spinners - minimum and maximum)

Restated that question is this - How can I make the maximum value on a
spinner to be variable? I want one spinner that will mark the starting
point
- from 1 to 51 (this will remain constant). The second spinner's minimum
would be 1 with a maximum of (52 - spinner 1's starting point}).

I'm currently using ver-2000 will be upgraded to 2003 soon