Userform to size to display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form called FormLOB. I have two monitors going (laptop and 21") with
different resoultions. I want my form to cover the entire screen on both.
How do I size this?
Any help please
 
Assuming you are only going to cover the worksheet with the form, you might
be able to use something like this.

Sub scrnsz()
x = Application.UsableHeight
y = Application.UsableWidth
MsgBox "Height is " & x & vbCrLf & "Width is" & y
End Sub
 
You should be able to use the msoScreenSize constants to do the job. See VBA
help file for msoScreenSize or ScreenSize.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top