How to align the form to the top left? Right now when the form is
initialized, it is centrally aligned.

Set the startup position in the initialize event.

Private Sub UserForm_Initialize()
UserForm1.StartUpPosition = 3
End Sub

--
HTH...

Jim Thomlinson


"Scott" wrote:

> How to align the form to the top left? Right now when the form is
> initialized, it is centrally aligned.

Private Sub UserForm_Initialize()
Me.StartUpPosition = 0
Me.Left = 0
Me.Top = 0
End Sub


--
Hope that helps.

Vergel Adriano


"Scott" wrote:

> How to align the form to the top left? Right now when the form is
> initialized, it is centrally aligned.

I should have mentioned my use of 3. In VB (not VBA) there are constants for
the start up position. Here they are

vbStartUpManual 0 No initial setting specified.
vbStartUpOwner 1 Center on the item to which the UserForm belongs.
vbStartUpScreen 2 Center on the whole screen.
vbStartUpWindowsDefault 3 Position in upper-left corner of screen.

VBA does not have the same constants but you can declare them if you wish...
I just used 3...
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

> Set the startup position in the initialize event.
>
> Private Sub UserForm_Initialize()
> UserForm1.StartUpPosition = 3
> End Sub
>
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Scott" wrote:
>
> > How to align the form to the top left? Right now when the form is
> > initialized, it is centrally aligned.

Thanks. It works.

I've also found that I can select "3 - Windows Default" under
"StartUpPosition" on "Properties" of the form.

"Jim Thomlinson" wrote:

> I should have mentioned my use of 3. In VB (not VBA) there are constants for
> the start up position. Here they are
>
> vbStartUpManual 0 No initial setting specified.
> vbStartUpOwner 1 Center on the item to which the UserForm belongs.
> vbStartUpScreen 2 Center on the whole screen.
> vbStartUpWindowsDefault 3 Position in upper-left corner of screen.
>
> VBA does not have the same constants but you can declare them if you wish...
> I just used 3...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Jim Thomlinson" wrote:
>
> > Set the startup position in the initialize event.
> >
> > Private Sub UserForm_Initialize()
> > UserForm1.StartUpPosition = 3
> > End Sub
> >
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "Scott" wrote:
> >
> > > How to align the form to the top left? Right now when the form is
> > > initialized, it is centrally aligned.

Thanks, it works.

"Vergel Adriano" wrote:

>
> Private Sub UserForm_Initialize()
> Me.StartUpPosition = 0
> Me.Left = 0
> Me.Top = 0
> End Sub
>
>
> --
> Hope that helps.
>
> Vergel Adriano
>
>
> "Scott" wrote:
>
> > How to align the form to the top left? Right now when the form is
> > initialized, it is centrally aligned.