Making a Label scrollable with a Scroll bar with User Forms

shy4x4

New Member
Joined
Oct 11, 2005
Messages
34
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
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Macropheliac

Board Regular
Joined
Aug 26, 2005
Messages
165
Are you sure you're using a label? The Textbox has a scrollbar property, but I don't recall the Label having one.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,859
Messages
5,544,710
Members
410,631
Latest member
JFORTH97
Top