UserForm On Launch Position - Lower Right Corner

[ranouilh]

I need a VBA comand to place a UserForm at the lower right corned of the screen when the form is called. It will need to work for different systems with different screen resolutions. Not sure if this exists and I could not find it if it does.
Thanks in advance to all who help with this.

 

[Jaafar Tribak]

Hi,

Can you adapt this : http://www.mrexcel.com/board2/viewtopic.php?t=184069&highlight=data+form to apply to your UserForm ?

If any probs, post back .

Regards.

 

[smozgur]

Hi,

Following code might help as well.

Private Sub UserForm_Initialize()
Dim tmpStatus As Long
  With Application
    tmpStatus = .WindowState
    .ScreenUpdating = False
    .WindowState = xlMaximized
    Me.StartUpPosition = 0 
    Me.Move .Width - Me.Width, .Height - Me.Height
    .WindowState = tmpStatus
    .ScreenUpdating = True
  End With
End Sub

You can remove "Me.StartUpPosition = 0" code line if you set userform StartupPosition as Manual in properties window.

Suat