Use two cells.

One for the link and one to do the multiplication.



Plum wrote:

Thanks, yes that does work, except that I need to have the cell it is linking
to as an input variable, not a formula. Any other ideas?

"Dave Peterson" wrote:

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


--

Dave Peterson