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