Zoom and Scroll Form

Hi All,

I would like to change my active sheet's zoom size using a Scroll or
Spinner... Not sure where to start -- any ideas?

TIA!

Jeff,

You can use the ActiveWindow.Zoom = [value] property to set the Zoom rate.
The challenging aspect is where to put the spinner/scroll bar. Since you
don't want it on a particular sheet, one idea is to create a custom control
and add it to a current command bar (or create a new one), then have that
control kick off a userform with that contains the spinner/scroll bar.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"JEFF" wrote:

> Hi All,
>
> I would like to change my active sheet's zoom size using a Scroll or
> Spinner... Not sure where to start -- any ideas?
>
> TIA!
>
>

Thanks for the response.... Actually, it can be on one particular sheet.
I'm not going to pretend to be an expert so... how do I tie this to the form?

Thanks

"galimi" wrote:

> Jeff,
>
> You can use the ActiveWindow.Zoom = [value] property to set the Zoom rate.
> The challenging aspect is where to put the spinner/scroll bar. Since you
> don't want it on a particular sheet, one idea is to create a custom control
> and add it to a current command bar (or create a new one), then have that
> control kick off a userform with that contains the spinner/scroll bar.
> --
> http://HelpExcel.com
> 1-888-INGENIO
> 1-888-464-3646
> x0197758
>
>
> "JEFF" wrote:
>
> > Hi All,
> >
> > I would like to change my active sheet's zoom size using a Scroll or
> > Spinner... Not sure where to start -- any ideas?
> >
> > TIA!
> >
> >