A userform has a startup position property which you can either manually
set or set prgrammably. the proptery has these options

Manual = 0 - No initial setting specified.
CenterOwner = 1 - Center on the item to which the UserForm belongs.
CenterScreen = 2 - Center on the whole screen.
WindowsDefault = 3 - Position in upper-left corner of screen.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160007

Microsoft Office Help