Display position of Userform

I want a userform to display at the top right side of the screen when it is
launched.

The userform StartUpPosition property gives me 4 options, none of which will
do what I want. Is there any code I can write that will show the form where
I want it to go?

I know it is possible to drag it over but I'd prefer it to start off where I
want it to be.

Hi Andy,

Try using the Top and Left properties of the Userform, e.g.:

'===========>>
Private Sub UserForm_Activate()
With Application
Me.Top = 0
Me.Left = 525
End With
End Sub
'<<===========

Change the values to suit.


---
Regards,
Norman


"AndyRoo" <[email protected]> wrote in message
news:[email protected]...
>I want a userform to display at the top right side of the screen when it is
> launched.
>
> The userform StartUpPosition property gives me 4 options, none of which
> will
> do what I want. Is there any code I can write that will show the form
> where
> I want it to go?
>
> I know it is possible to drag it over but I'd prefer it to start off where
> I
> want it to be.

Just what I needed, tweaked the numbers a little and it's perfect. Thanks a
lot.

"Norman Jones" wrote:

> Hi Andy,
>
> Try using the Top and Left properties of the Userform, e.g.:
>
> '===========>>
> Private Sub UserForm_Activate()
> With Application
> Me.Top = 0
> Me.Left = 525
> End With
> End Sub
> '<<===========
>
> Change the values to suit.
>
>
> ---
> Regards,
> Norman
>
>
> "AndyRoo" <[email protected]> wrote in message
> news:[email protected]...
> >I want a userform to display at the top right side of the screen when it is
> > launched.
> >
> > The userform StartUpPosition property gives me 4 options, none of which
> > will
> > do what I want. Is there any code I can write that will show the form
> > where
> > I want it to go?
> >
> > I know it is possible to drag it over but I'd prefer it to start off where
> > I
> > want it to be.
>
>
>