Increase Max Value of Spinner

[Lon]

The Maximum Value of the "Spinner" form is 30,000. Is there any way to
increase it? I'd like to bump the maximum value up into the millions.

 

[Peo Sjoblom]

You can use the spinner button from the control toolbox instead

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Lon]

Peo,

Ah . . . yes. Now I see that there are two types of spinners.

I was using the spinner from the Forms tool bar, which is easy to "program."
That is, it has its own Format Control dialog box, which makes it easy to
assign its actions to data in a named cell.

I see that the spinner button from the control tool box is "programmed"
through a Properties box. I also see where (in the Properties box) to set
the maximum value and the linked cell. I take it, though, that there's still
more to do. Is this where I have to learn some VBA, or is there some simple
step I'm overlooking, that will get the spinner button from the control box
to work?

Thanks again,

-Lon


The Spinner I have been using is the one I got from the control box.

 

[Dave Peterson]

It should be that simple. But make sure you're out of design mode (another
button on that Control toolbox toolbar).

But that's a pretty large number for a spinner. Have you thought of using a
scrollbar (also from the control toolbox). It might be easier for the user to
get to the number they want.

 

[Lon]

Dave,

You were right . . . on both counts.

I was still in design mode. And now that I've clicked out of that mode, the
spinner works just fine.

I'm using large numbers because I'm designing a decision tree to be used by
trial lawyers, and the numbers are dollars. These days, lawsuits often
involve amounts in the millions of dollars. I thought I'd deal with the
problem you alluded to by having the spinner increase the amounts in
increments of $1,000. But the scrollbar works too, even better, and even in
increments of just $1.

Thanks . . . "a million."

-Lon