Using Userforms with and without a dual screen

Hi guys

i have recently started using dual screen on my desktop and have come across a problem

when i run a userform it always appears in the wrong place.
usualy it appears dead center of the excel window that executed it.

now it appears at the top-left or center left of my second screen.
to counter this i had set the top/left values in properties so that the userform is in a more pleasing position

but now if somone without dual-screens runs the form appears at the far left of their screen

surley somone has had this problem before

i have had a search in the forum but couldnt find anything.

hi Friel, would that be helpful:

StartUpPosition Property

Returns or sets a value specifying the position of a UserForm when it first appears.

You can use one of four settings for StartUpPosition:

Setting Value Description
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.

Remarks
You can set the StartUpPosition property programmatically or from the Properties window.

Example:

Private Sub UserForm_Initialize()
UserForm1.StartUpPosition = 1
End Sub

they are the settings i have been playing with

this is the result

Manual 0 - top, left of screen 2
CenterOwner 1 - Center height , left of screen 2
CenterScreen 2 - Center height , left of screen 2
WindowsDefault 3 - top, left of screen 2

This is quite frustrating

That works like a Dream

Thanks!
this has been doing my headin for a few weeks now

Rep added