By anything, do you mean any real number?

12345.3241235

or do you mean any value that's a multiple of 1000?

If it's the second, maybe you could allow 5 to 1000, but use another cell to get
the number:

=A1*1000
where
A1 is the linked cell for the spinner.

Plum wrote:

Hi there,
I have discovered that there seems to be an upper limit for spin buttons. I
am trying to create one that will allow the user to enter anything between
$5,000 and $1,000,000 but the format control section is only allowing a
maximum value of 30,000. Any idea on how I can get around this?
I am using Excel 2007 and form controls, not Activex.
Thanks in advance.

--

Dave Peterson