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...

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" <[email protected]> skrev i melding
news:[email protected]...
> 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...
>

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