Increase Max Value of Spinner

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.
"Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
news:%23Gh9B7YYGHA.4620@TK2MSFTNGP04.phx.gbl...
> 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" <sobel@entertainmentlawreporter.com> wrote in message
> news:sdw0g.3416$oQ2.301@trnddc05...
>> 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.
>>
>
>

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 wrote:
>
> 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.
> "Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
> news:%23Gh9B7YYGHA.4620@TK2MSFTNGP04.phx.gbl...
> > 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" <sobel@entertainmentlawreporter.com> wrote in message
> > news:sdw0g.3416$oQ2.301@trnddc05...
> >> 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.
> >>
> >
> >

--

Dave Peterson

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

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:4442D1EB.B1CB207E@verizonXSPAM.net...
> 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 wrote:
>>
>> 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.
>> "Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
>> news:%23Gh9B7YYGHA.4620@TK2MSFTNGP04.phx.gbl...
>> > 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" <sobel@entertainmentlawreporter.com> wrote in message
>> > news:sdw0g.3416$oQ2.301@trnddc05...
>> >> 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.
>> >>
>> >
>> >
>
> --
>
> Dave Peterson

I know this is attached to an old post ... and I did manage to update the maximum for the slider - I need to do increments of $10,000. I have it with a Large Change of 10000, a Small Change of 10000 - and if I click on the slider it does go up in increments of 10,000 - but if I slide it it goes by $1.00... how do I correct that?