PDA

View Full Version : Simple problem with form sizing



AmardeepD
03-13-2008, 03:56 AM
Ok a really simple problem and i think im just being dense. I want to have the form to display maximised across the whole screen but cant figure out how to do this ... i know im just being dense but after 3 days with no sleep and crazy workload its understandable haha

:rotlaugh:

MikeO
03-13-2008, 07:49 AM
Try something like this:
Sub MaximizeForm()
UserForm1.Top = 0
UserForm1.Left = 0
UserForm1.Width = ActiveWindow.Width
UserForm1.Height = ActiveWindow.Height
UserForm1.Show
End Sub


or this:
Sub MaximizeForm()
UserForm1.Top = Application.Top
UserForm1.Left = Application.Left
UserForm1.Width = Application.Width
UserForm1.Height = Application.Height
UserForm1.Show
End Sub