Simple problem with form sizing

[AmardeepD]

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

[MikeO]

Try something like this:
[vba]Sub MaximizeForm()
UserForm1.Top = 0
UserForm1.Left = 0
UserForm1.Width = ActiveWindow.Width
UserForm1.Height = ActiveWindow.Height
UserForm1.Show
End Sub
[/vba]

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