Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 209
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 209
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Startup chefmike Excel Discussion (Misc queries) 1 November 3rd 07 01:44 AM
Startup BillCPA Excel Discussion (Misc queries) 2 May 30th 06 09:19 PM
Exel VBA- userform startup problem officemanager Excel Programming 2 July 20th 04 04:44 PM
Startup scottwilsonx[_4_] Excel Programming 4 July 6th 04 05:24 PM
Userform inside another userform Ryan Excel Programming 0 April 23rd 04 08:01 PM


All times are GMT +1. The time now is 03:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"