Userform to size to display
 

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
--
Jason V

Userform to size to display
 

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

"Jason V" wrote:

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
--
Jason V

Userform to size to display
 

You should be able to use the msoScreenSize constants to do the job. See VBA
help file for msoScreenSize or ScreenSize.

"Jason V" wrote:

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
--
Jason V