Positioning a user form

[Fire_Chief]

How do I get a user form to appear at the bottom and center of the screen no matter what the screen resolution is?
I use it on my laptop and my desktop and they have different screen resolutions which I can't make the same.

I get it to open at the bottom but always below the sheet bottom. It is below the task bar when it opens.

I know you can move the user form but many others do not.

Thank you

 

[rlv01]

This code, placed in the form's code module, will center the form on the monitor. You'll have to test it to see how it handles your resolution issue. You can play around with the positioning parameters to position it to your liking.

Private Sub UserForm_Activate()
    With Me                           ' Center Screen on whatever monitor Excel is running on
        .StartUpPosition = 0
        .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
        .Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)

        If .Height > Application.Height Then
            .ScrollHeight = .Height
            .Width = .Width * 1
            .Height = .Height * 0.8
            .Zoom = 100
            .Top = .Top + 60
            Me.KeepScrollBarsVisible = fmScrollBarsVertical
            Me.ScrollBars = fmScrollBarsVertical
        End If
    End With
End Sub

 

[dmt32]

Have a look here:Form Positioner

Dave

 

[Fire_Chief]

Thanks Dave but that's a little too heavy for me... Must be an easier way

 

[Fire_Chief]

Going to try the first suggestion on desktop and laptop//