Hi,

I think we are missing something here. You can't want to use a spinner to
enter 1,000,000. That would require 1,000,000 clicks?

Some FYI - The Form's Spinner has a maximumn value of 30,000 but the Control
Toolbox's Spinner allows whole numbers to 2,147,483,647.

You also might consider using the Control Toolbox's Scrollbar control,
because you can set a Large change and Small change imcrements. For example,
small could be 1 and large could be 1000.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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.