define collection class for scrollbars from Forms toolbar

[sifar786]

Hi,

i have multiple scrollbars in a worksheet. these scrollbars were added using the Forms Toolbar. i want to create a class file which will add these scrollbars into a collection so that i can manipulate any scrollbars change event.

in the class file, for Control Toolbox Scrollbar, we generally write,

Public WithEvents Scroller as MSForms.Scrollbar

what do we write for a Scrollbar added from a Forms toolbar?

 

[Andrew Poulsom]

Controls from the Forms Toolbar don't have events as such. You can assign them a macro using the OnAction property. Use Application.Caller to return the name of the Control that was changed and act accordingly. Example:

Sub ScrollBar_Change()
    MsgBox "You changed ScrollBar " & Application.Caller
End Sub

 

[sifar786]

Thanks Andrew