Positioning a Userform

[Don Wells]

Earlier today I came across values which would set the startup position of a userform when shown. I can see only four options. Is anyone aware of a technique which will position the userform in the bottom left corner of the screen?
    
T.I.A.

[Becks]

First, set form's StartUpPosition to Manual (0)
then

Code: Select all

Private Sub UserForm_Initialize()
     With Application
        Me.Left = .Left + .Width - Me.Width
        Me.Top = .Top + .Height - Me.Height
    End With
End Sub

Kevin

[Don Wells]

First, set form's StartUpPosition to Manual (0)
then

Code: Select all

Private Sub UserForm_Initialize()
     With Application
        Me.Left = .Left + .Width - Me.Width
        Me.Top = .Top + .Height - Me.Height
    End With
End Sub

Kevin

Thanks for the insight Kevin.    That gave me the bottom right.    I got the bottom left with:

Code: Select all

Me.Left = .Left

[Becks]

Left ?

You really wanted it on the bottom RIGHT - I could tell
(it makes for more instructive code)

Kevin