Use a scroll bars in userforms

[richanor]

Hi

Can I use a scroll bar to set the value in a text box, within the same userform (the scroll bar is a separate object). If so how do I do this? I wondered if it would be as simple as just identifying a 'target object' in the properties of the scroll bar, but apparently not. Any help appreciated.

Rich

 

[richanor]

No worries guys - I've figured it out, just needed to add a line of code:

Private Sub Slider_Change()

Textbox.Text = Slider.Value

End Sub