Trapping ScrollBar's Scroll Amount
 

I'm trying to trap the scroll amount on a scroll bar (from the Forms
toolbox), and keep getting the dreaded "Object required" error...I hate
that... I know I need more than the ScrollBar6.Value, but can't figure
out what...

Any help would be appreciated...thanks...

Trapping ScrollBar's Scroll Amount
 

Hi

MsgBox Sheets(1).ScrollBars(1).Value
MsgBox Sheets(1).DrawingObjects("Scroll Bar 1").Value
MsgBox Sheets(1).ScrollBars("Scroll Bar 1").Value

HTH. best wishes Harald

"Gene" skrev i melding
ups.com...
I'm trying to trap the scroll amount on a scroll bar (from the Forms
toolbox), and keep getting the dreaded "Object required" error...I hate
that... I know I need more than the ScrollBar6.Value, but can't figure
out what...

Any help would be appreciated...thanks...

Trapping ScrollBar's Scroll Amount
 

Works great...thanks for the help...