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