Display my UserForm on the far left of the screen

[C_Rieker]

I have a UserForm that I named UF_Home. On initialisation, the UserForm ensures that the application is set to maximised, my UserForm is set to display to far left of the application and then the Excel application is set to Visible=False.

My issue is that the UserForm has a small gap on the far left of the screen. How to I move it over that tiny bit?

Also, I have tried to do

.Left = Application.Left - 5

but this doesnt change the left positioning (Even if I do 100 instead of 5)

Private Sub UserForm_Initialize()

    Application.WindowState = xlMaximized

    With UF_Home
        .Width = Application.Width
        .Height = Application.Height
        .Left = Application.Left
        .Top = Application.Top
    End With
    
    Application.Visible = False

End Sub

Below is a screenshot. Note the gap on the far left and how the UserForm is slightly cut off on the far right.

Cheers in advanced you amazing people

 

[Michael M]

You could make the UserForm take up the full screen...here

How to make a VBA Userform - Full Screen

Mr Excel, I have created a userform in Visual Basic which automatically pops up when a workbook is opened. I would like it to appear in full screen mode ie self adjust to the users PC display settings / acceleration. Is there a way to do this...if not I will have to design the form a little...

www.mrexcel.com

Or
this thread may give you some further ideas

Userform Startup Position

I need the userform I made to display in the top right corner of the worksheet. I can manually set the position but when the workbook is opened on a different computer with a different screen resolution the userform is almost completely off the screen. What VBA code could have the userform...

www.mrexcel.com

 

[C_Rieker]

You could make the UserForm take up the full screen...here

How to make a VBA Userform - Full Screen

Mr Excel, I have created a userform in Visual Basic which automatically pops up when a workbook is opened. I would like it to appear in full screen mode ie self adjust to the users PC display settings / acceleration. Is there a way to do this...if not I will have to design the form a little...

www.mrexcel.com

Or
this thread may give you some further ideas

Userform Startup Position

I need the userform I made to display in the top right corner of the worksheet. I can manually set the position but when the workbook is opened on a different computer with a different screen resolution the userform is almost completely off the screen. What VBA code could have the userform...

www.mrexcel.com

Thank-you for your prompt reply. However, after following these suggestions, my UserForm still displays with a gap to the left.

 

[Jaafar Tribak]

Just place this line at the start of your code:

UF_Home.StartUpPosition = 0

 

[C_Rieker]

Just place this line at the start of your code:

UF_Home.StartUpPosition = 0

Thank-You so much. I can't believe I missed something so simple. You are a champion.