Userform to autofit window size of any user

[dss28]

I have developed a program having userforms all in one size of 450 (height) x 780 (width), userform zoom property set to 85.
I used the following code to autofit the form to users window size. However some portion of the form is not visible and goes out of window which can not be seen.
can we add a scroll bar to the userform or is there any thing wrong in the userform size?
what should be the size of the userform if this code gives perfect window fit?
pl. help.

Private Sub UserForm_Initialize()
With Application
.WindowState = xlMaximized
Zoom = Int(.Width / Me.Width * 100)
Width = .Width
Height = .Height
End With
End Sub

 

[EXCEL MAX]

Hello Dss28,
if you want active scrollbars on the userform you need to set few userform's property.
It's number of the active "ScrollBars", resize "ScrollHeigtt" and "ScrollWitdth" to be greater than userform size.