Position of Userform when appear

[Lexian]

Hi all,

I have a userform, and it pop up when triggered and I have two monitors.
I want it to appear on the same position where my excel is.

If my excel is on primary monitor, then the userform will appear on primary, same if my excel is on secondary monitor. it has to appear on secondary. basically, the userform should appear on the same monitor where my excel sheet is.

Can someone help me to fix this? Thank you in advance.

 

[Vbagreenhorn1]

maybe this is the solution?

https://www.mrexcel.com/forum/excel-questions/459677-userform-screen-placement.html