startup a userform
 

Hi
Can i start my userform so it allways
startup in upper right corner of the screen
and maybe allways on top of the screen
so if another application startup the
userform still is on top
Regards alvin

startup a userform
 

Hi Alvin

You can use this event to startup in upper right corner

Private Sub UserForm_Initialize()
Me.StartUpPosition = 0
Me.Top = Application.Top
Me.Left = Application.Width - Me.Width + Application.Left
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Alvin Hansen" wrote in message ...
Hi
Can i start my userform so it allways
startup in upper right corner of the screen
and maybe allways on top of the screen
so if another application startup the
userform still is on top
Regards alvin

startup a userform
 

Hi Ron
Thanks for your help
It's working

Thank you

alvin


"Ron de Bruin" skrev:

Hi Alvin

You can use this event to startup in upper right corner

Private Sub UserForm_Initialize()
Me.StartUpPosition = 0
Me.Top = Application.Top
Me.Left = Application.Width - Me.Width + Application.Left
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Alvin Hansen" wrote in message ...
Hi
Can i start my userform so it allways
startup in upper right corner of the screen
and maybe allways on top of the screen
so if another application startup the
userform still is on top
Regards alvin