I am using a dual monitor screens, and having trouble displaying a UserForm centered on the same screen that Excel is being displayed on.

The application is maximized, and when the UserForm is displayed, it appears on the secondary screen when the StartUpPosition property is set to Manual, CenterOwner, or CenterScreen.

If I set the StartUpPosition property to Windows Default, the UserForm appears on the primary screen in the upper left.

I would really like to display the UserForm on the same screen as Excel is being displayed on, centered both vertically and horizontally on the screen.

Is there a VBA way of doing this, or is there API functions that will help me.

Thanks All!