Userform scrollbar nightmare!
OK i've figured;
With Me
Label1.Move ((.InsideWidth - Label1.Width) / 2),
((.InsideHeight - Label1.Height) / 2)
.ScrollBars = fmScrollBarsBoth
.ScrollHeight = 3000
.ScrollWidth = 1200
.ScrollTop = 0
End With
However my problem is now that the form doesn't fit to the page, but
disappears off the bottom of the page - any suggestions (i thought
making it modal would work but no luck)
|