Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Startup | Excel Discussion (Misc queries) | |||
Startup | Excel Discussion (Misc queries) | |||
Exel VBA- userform startup problem | Excel Programming | |||
Startup | Excel Programming | |||
Userform inside another userform | Excel Programming |