find out users resolution

I have a userform which I would like it to stretch to the max size of the screen? Is this possible?

If it is will this keep this in the right position and just basically zoom in?

Hello FunkymonkUK,

Here is the API code to return the screen resolution.

Delcare Function GetSystemMetrics Lib "user32.dll" (ByVal nIndex As Long) As Long

Const SM_CXSCREEN As Long = 0
Const SM_CYSCREEN As Long = 1

Public Function ScreenWidth() As Long
 ScreenWidth = GetSystemMetrics(SM_CXSCREEN)
End Function

Public Function SreenHeight() As Long
 ScreenHeight = GetSystemMetrics(SM_CYSCREEN)
End Function

Hope this helps,
Leith Ross