Userform to Fill Entire Screen

[Andry143]

I would like my userform to automatically size itself to fill the entire screen. Is this possible? If yes, where are the settings or what initialization code do I need to include?

Thanks for the help.

Jason

 

[onlyadrafter]

Hello,

TO override the position,you need to change StartUpPosition to Manual, and have TOP and LEFT both 0.

Will work on the size, obviously change the WIDTH and HEIGHT as required.

(PS- tks for being my 3000th post!)

 

[Andry143]

Thanks for the help.

Jason

 

[HalfAce]

I would like my userform to automatically size itself to fill the entire screen. Is this possible?

Hello Jason,
Rather than hard coding the startup position, height & width you can also use this in
the userform's initialize event.

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