| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform to appear in the center of the screen
See StartUpPosition in the VBA Help. CenterOwner is the position preset for
the UserForm. "ernie" wrote: how can i get my userform to appear in the center of the screen even if i change my screen resolution settings. i use the code below with screen resolution of 1024 by 768 pixels. Private Sub Workbook_Open() Application.WindowState = xlNormal Application.Top = 250 Application.Left = 320 Application.Height = 1 Application.Width = 1 End Sub -- Thank you for your help i appreciate it. Ernie |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
userform to appear in the center of the screen
thank you for all your help it worked
-- help a friend help you "JLGWhiz" wrote: See StartUpPosition in the VBA Help. CenterOwner is the position preset for the UserForm. "ernie" wrote: how can i get my userform to appear in the center of the screen even if i change my screen resolution settings. i use the code below with screen resolution of 1024 by 768 pixels. Private Sub Workbook_Open() Application.WindowState = xlNormal Application.Top = 250 Application.Left = 320 Application.Height = 1 Application.Width = 1 End Sub -- Thank you for your help i appreciate it. Ernie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Center Comments on Center of Screen | Excel Discussion (Misc queries) | |||
| How do you keep a Dialog Box in the center of the screen? | Excel Programming | |||
| Making comments appear in the center of the screen. | Excel Discussion (Misc queries) | |||
| How do i center a worksheet in the view screen | Excel Discussion (Misc queries) | |||
| UserForm position other than center of the screen. | Excel Programming | |||
Linear Mode
