If some users are having a screen overflow, it could be because they have
their screen resolution set to an unconventional setting. If so, they are
forcing you to alter a standard feature to meet their non-standard whims. I
would check their settings before trying to accommodate them.


"Ryan H" wrote in message
...
I don't think I need to expand the userform to fit the screen. I need to
shrink the userform. Any ideas?
--
Cheers,
Ryan


"Jacob Skaria" wrote:

Try the below

Private Sub UserForm_Initialize()
With Me
.Height = Application.Height
.Width = Application.Width
.Left = 0
.Top = 0
End With
End Sub

--
If this post helps click Yes
---------------
Jacob Skaria


"Ryan H" wrote:

I have many different users for one of my workbooks. The workbook has
many
different sized userforms. Some userforms are too large for the users
screen. Is there a way for VBA to automatically adjust the userform to
fit
in the users screen properly like other software does?
--
Cheers,
Ryan