View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
anon anon is offline
external usenet poster
 
Posts: 77
Default 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)