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!

Zoom and Scroll Form
 

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!

Zoom and Scroll Form
 

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!