Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Thelma Murray   on Oct 05 In MS Office Category.

How can i get the Resolution of the screen?


  
Question Answered By: Laurie Lawrence   on Oct 05

Not exactly what you describe (Full Screen), but this code (placed in the
UserForm_Initialize module) will make the form the same size as the active EXCEL
window.

' Size the window to match size of EXCEL window
With Application
Me.Top = .Top
Me.Left = .Left
Me.Height = .Height
Me.Width = .Width
End With

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How can i get the Resolution of the screen? Or get search suggestion and latest updates.


Tagged: