Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How can i get the Resolution of the screen?

  Asked By: Thelma    Date: Oct 05    Category: MS Office    Views: 521
  

I'm making a userform in Excel which is big as fullscreen. I need to know the
resolution of the screen. I mean if i make it for 1024x768,then user won't see
all in 800x600 resolution. Is there anybody who knows the answer? Must i use
API?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Laurie Lawrence     Answered 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

 
Answer #2    Answered By: Madaniyah Malik     Answered On: Oct 05

I think you'll have to use API. See
http://www.mrexcel.com/archive2/55100/64028.htm

 
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: