Increase Max Value of Spinner

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?