Userform & Excel window

  • Thread starter Thread starter D.S.
  • Start date Start date
D

D.S.

Does anyone know if I can load a user form, and either ;
1) code it to be fullscreen or maximized
2) or, make the Excel window where it is NOT visible behind the userform?

D.S.
 
DS,

Try something like the following to resize the form to fill the entire Excel
window.

With Application
UserForm1.Move .Left, .Top, .Width, .Height
End With
UserForm1.Show

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Does anyone know if I can load a user form, and either ;
1) code it to be fullscreen or maximized
2) or, make the Excel window where it is NOT visible behind the userform?

D.S.
 
You can also try something like:

application.Visible = False
Userform1.show
Application.visible = True

--
Regards,
Tom Ogilvy

Does anyone know if I can load a user form, and either ;
1) code it to be fullscreen or maximized
2) or, make the Excel window where it is NOT visible behind the userform?

D.S.
 
Thanks Chip & Tom. That will work nicely.

D.S.
You can also try something like:

application.Visible = False
Userform1.show
Application.visible = True

--
Regards,
Tom Ogilvy

Does anyone know if I can load a user form, and either ;
1) code it to be fullscreen or maximized
2) or, make the Excel window where it is NOT visible behind the userform?

D.S.
 
Back
Top