userform always fits the screen

[kirana2014]

Hello,

I'm a begginer in VBA and I have made for a Userform to make things easier for the users. I have noticed that I have sized the userform to fit a 22 inch desktop screen but it won't fit on laptops and smaller screens.

Is there a way so that the userform always fits the screen?

I appreciate beforehand your attention and time.


Kirana

[gmr4evr1]

Have you tried...

Private Sub UserForm_Initialize()

With Application
    Me.Top = .Top
    Me.Left = .Left
    Me.Height = .Height
    Me.Width = .Width
End With

End Sub

Or maybe something from this post will help
http://www.excelforum.com/excel-prog...-userform.html