Frame and Scrollbar 1

[longshot3001]

I have currently created a frame which contains a several labels within it. My labels resize determining how many students are listed on the excel spreadsheet. The problem I have is when my labels become larger than my frame I would like to be able to scroll and view the rest of the labels information.

 

[LSTAN]

Hi longshot3001

Just set the scroll height to the value of the label height,
here is how;

With Me.Frame1
.ScrollBars = fmScrollBarsVertical
.ScrollHeight = Me.Label1.Height
End With

Hope this helps

rgrds
LSTAN

 

[longshot3001]

Yes that works fantastic,

Thanks