need help to get user form in fullscreen

[mandarp22]

Hi All
I have a Excel file with open event which hides the application and show only user form but the user form is small in size. I want the form to open in Maximized State.
any help?

Regards
Mandar

 

[NARAYANK991]

Hi ,

See if this helps :

https://www.mrexcel.com/forum/excel-questions/86034-set-userform-full-screen.html

Narayan

 

[shrivallabha]

Try putting in Userform's initialize event like below:

Private Sub UserForm_Initialize()
    Me.Height = Application.UsableHeight
    Me.Width = Application.UsableWidth
End Sub

 

[Belleke]

Something like this??

 

[mandarp22]

Belleke's solution works great for me
Thank you