C_Rieker
New Member
- Joined
- Nov 22, 2020
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
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
but this doesnt change the left positioning (Even if I do 100 instead of 5)
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
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
VBA Code:
.Left = Application.Left - 5
VBA Code:
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