Making a Label scrollable with a Scroll bar with User Forms

[shy4x4]

Hi all,

I have put a lot of data into a Label in a user form and i want the reader to be able to scroll through the information using a Scroll Bar.

I have the scroll bar in the user form however when i run the user form and click on the scroll bar to scroll nothing happens. What is the coding i need to tell the scroll bar to scroll down when someone clicks the down arrow and visa versa.

Private Sub Label1_Click()

End Sub

Private Sub ScrollBar1_Change()

End Sub

That is all I have at the moment. Please help!

Thanks guys,

Jason

 

[Macropheliac]

Are you sure you're using a label? The Textbox has a scrollbar property, but I don't recall the Label having one.