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.

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

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

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

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.